Dates in a query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jen - 29 Mar 2006 16:28 GMT

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.

Reply to this Message

Jeff Boyce - 29 Mar 2006 16:52 GMT

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

> what is the correct criteria in a query for searching records with current
> date only.
[quoted text clipped - 7 lines]
> see
> the ones scheduled daily and not the rest.

Reply to this Message