Query Criteria using a Time Field

[Guest]

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?

 

[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

 

[Guest]

hour(dateadd("d",1,now)) < 5