Criteria Problem

I

Irons

Hi All,

I have a query with a date field that is from a table where the date is
looked up from another table. I am trying to enter a Between [start date] and
[end date] criteria into the query but everytime I enter the dates I want to
retrieve I just get an error message saying the expression is invalid. Can
anyone point me in the right direction please?
 
J

Jerry Whittle

When you type in the criteria in all lower case, do the "b" in "between" and
"a" in "and" change to upper case when you click out of the criteria block?

Is the field in question an actual Date/Time field or a text field with
things that look like dates?

If it's a lookup, are you sure that the value that links the tables is
actually the dates OR something like a primary key autonumber? (I hate lookup
fields for this reason)

Have you defined the parameters as Date/Time by going up to Query, Parameters?
 
Top