Hi,

I have a table column filled with dates and I just want to query a certain date.

How do I do this?

Do I use the 'Like' ?

Suolon

Build your query. Then in the Criteria cell for the date field put:
[Enter Date]

Then when you run the query, you will be prompted to enter a date. Enter the date in the format m/d/y.

Like is only used for text fields. Date/time fields are numeric.

Thanks! it works perfectly http://www.access-programmers.co.uk/ubb/smile.gif