Query on Today's Date

  • Thread starter Thread starter markmidwest
  • Start date Start date
M

markmidwest

What would be the criteria for running a query on today's
date?

I don't want to have to enter anything, just match the
field & get anything for today.

Thanks for your help.
 
In the Criteria row of your query - in the column for your Date field,
insert:

Date()

hth,
 
You've had 3 good answers. I just thought I'd point out that if the field in
your table also includes time (because it was populated using the Now
function), none of those answers will work.

In that case, you'll need to use:

WHERE [yourDateColumn] BETWEEN Date() And Date()+1

as your criteria

or else

WHERE DateValue([yourDateColumn]) = Date()
 
Back
Top