query Time/date today between 6am to 6Pm

K

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

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.
Click to expand...

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