Query on Today's Date

[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.

 

[Cheryl Fischer]

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

Date()

hth,

 

[Rick]

in the date field's crieria you would enter

=date()

 

[Gerald Stanley]

Try
WHERE [yourDateColumn] = Date()

Hope This Helps
Gerald Stanley MCSD

 

[Douglas J. Steele]

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()