Data type mismatch in criteria expression

[Meg]

I get the Data type mismatch in criteria expression using the following on a
Date:

=#10/1/2008# And <=#9/30/2009#

this criteria signafies Fiscal year 2009

I can use any other FY 2008 or 2010 or 2011, etc. and it works fine

Can anyone help?

MEG

 

[Mark A. Sam]

MEG,

I tried your this expression and it worked fine. Try compacting and
repairing your database. If that doesn't help try decompiling it.

God Bless,

Mark A. Sam

 

[KARL DEWEY]

Your field for Fiscal Year is either a number or text field and not a date
field.

Try >=2008 And <=2009
OR

 

[Meg]

Thanks a bunch.

Someone had put a NA in a number field. and that was the problem. I have
to figure out how to not let them put in letters in a number field. However,
they enter the info in infopath, and I am not sure how I can do that. Any
ideas?

Thanksm

MEG

 

[KARL DEWEY]

It must be a text field as you can not put letters in a number field.
Open the table in design view and check the property.

 

[Meg]

Thanks again. It was a text field. Duh! I should have known that.

MEG