Multiple criteria query 1

[AnalystNovie]

I have a field for TIME, is there a way I could search for more than one TIME in 1 query?

My report has to show this . . .
name date onduty lunchout lunchin offduty

so I give the query the week I am looking for but I need to pull out the times the employee clocked in/out from a TIME field.

something like on duty between 7:00 and 7:30, and lunch out between 11:30 and 12, etc etc, and the the query result would return the actual times the employee clocked.

 

[Golom]

Select EmplID, DTField
From tbl
Where TimeValue(DTField) BETWEEN #7:00 AM# AND #7:30 AM#
   OR TimeValue(DTField) BETWEEN #11:30 AM# AND #12:00 PM#