Use [Time] in where clause

[phake123]

I'm trying to put a constraint on my records I want to retrieve by a time

ex.

Select name
from tblTechSupport
where dateOfCall between time1 and time2;

how would i do this im MS Access.

Any help is greatly appreciative

 

[a.sinatra]

do you want a specified value that is never going to change?
________
Medical Marijuana

 

[phake123]

No time1, time2 will always be changing.

I just want to know the format to tell Access that [time1] is a time

 

[a.sinatra]

If your table is already set up as a Date/Time, just use that and search for your times, but you must include AM and PM (ex. 9:00 AM or 7:00 PM)

Select Name
from tblTechSupport
Where DateOfCall between [TimeOne] and [TimeTwo];

________
Marijuana Dispensaries