access queries, by current date only

  • Thread starter Thread starter Lee
  • Start date Start date
L

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
 
Hi,
I assume you have a date field in your query.
Just set the criteria of this field to Date()
 
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.
Click to expand...

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
 
Back
Top