Creating a "Greater Than Date" criterion

[PlarfySoober]

I have created a query, all the fields from an existing table.

One field has a date format. I want to select for records in which that
field contains data.

I tried >"01/01/2000", but no joy. Message was "Data type mismatch in query
expression." This is the way to create this criteria, AFAICT in the Help
file, where it shows > '01 Jan 1995' as the proper way to select for later
dates than that one. But mine doesn't work.

Thanks in advance.

Don.

 

[Douglas J. Steele]

Dates need tobe delimited with #, not quotes.

Try

 

[PlarfySoober]

Just as you said. And the Help file is wrong, because it makes no mention of
using ## instead of '' or "". Thank you very much.