Dates in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date lookup in Table 2
Please help. Question about querying a subform 4
next date?? 1
Running Sum in Query 2
Changing constants in a query to user input values 2
Multiple Admission Dates 11
Delete Duplicates 2
average time between two date ranges 2

Back
Top