access queries, by current date only

[Lee]

I'm trying to get the query to select only the records
for the current date and have had no success to this
point. I have tried every combination of validation rules
and exprections I can think of. Any help would be great.

Example: Today is 10/21/03, only pull records date
10/21/03.

Thanks Lee

 

[Dan Artuso]

Hi,
I assume you have a date field in your query.
Just set the criteria of this field to Date()

 

[John Vinson]

I'm trying to get the query to select only the records
for the current date and have had no success to this
point. I have tried every combination of validation rules
and exprections I can think of. Any help would be great.

Example: Today is 10/21/03, only pull records date
10/21/03.

If the field contains just a pure date, with no time component, use a
criterion of

=Date()

If it does contain a time - i.e. if you're filling the field using the
Now() function - use a criterion of