Query Criteria using a Time Field

A

aMack

We have an appointment schedule which rolls over to the next day.

The query I am creating can pull data for "Today" and all "Times" but I also
need the data for "Tomorrow" with "Time" prior to 5:00 AM.

How do I generate such a query criteria prompting for todays date only?
 
J

John Spencer

Does your field contain both date and time? If so,

Field: AppointmentDateTime
Criteria: Between [Enter Start Date] AND DateAdd("h",29,[Enter Start Date])

That will catch any time up to and including 5:00:00 AM.

If you want you can make a slight change to get everything up to but not
including 5AM

Field: AppointmentDateTime
Criteria: >= [Enter Start Date] AND < DateAdd("h",29,[Enter Start Date])

I
 
Top