query Time/date today between 6am to 6Pm

[Kyle]

In my form, I have a field name Time/date in the format of
Mon, Sept. 21, 2003 @ 9:00:00 Am; I like to set up a
criteria so that in my list box only shown list between 6am
to 6pm today and those from yesterday will not list on my
list box.

Any help would be appreciated.

 

[John Vinson]

In my form, I have a field name Time/date in the format of
Mon, Sept. 21, 2003 @ 9:00:00 Am; I like to set up a
criteria so that in my list box only shown list between 6am
to 6pm today and those from yesterday will not list on my
list box.

Any help would be appreciated.

Base the Listbox on a query with a criterion on the Time/Date field of