Date Range Help

[JJT]

Help......I have a query where I need to select records within a date range:

Equal to or Greater Than 8/1/2002 and
Less Than or Equal to 7/31/2003.

I tried " >=#8/1/2002# and <=7/31/2003", but get all the records in the table.


Thanks

 

[dcx693]

I think I see the problem and I'll give you a hint.

If you asked for all numbers >1 and all numbers <3 you would basically get infinity.

Try using the Between keyword.

 

[JJT]

Thanks. The "between" function worked. Another question!
In the same query I also need the records where the "code" is TO or PR or GA.

 

[dcx693]

Try:
In ("TO","PR","GA")
in the criteria line of the code field.