Data type mismatch in criteria expression

  • Thread starter Thread starter Meg
  • Start date Start date
M

Meg

I get the Data type mismatch in criteria expression using the following on a
Date:
=#10/1/2008# And <=#9/30/2009#
Click to expand...

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
 
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
 
Your field for Fiscal Year is either a number or text field and not a date
field.

Try >=2008 And <=2009
OR
 
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
 
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.
 
Back
Top