Dates in a query

J

Jen

what is the correct criteria in a query for searching records with current
date only.

like 03/29/06 and nothing before or after that date on 03/29/06?(automatic
for todays date, 03/30/06 for tomorrow, etc....)

I do not want to type the date everytime I open the report.

I input my employees one month prior to them working but I only want to see
the ones scheduled daily and not the rest.
 
J

Jeff Boyce

Jen

Something to consider ... if the field has a date/time value OTHER than just
the date, you'll have to work a little harder. If it only holds the date
(the time portion is 0 - midnight), you can use the following as the
criterion in your query:

Date()

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top