I have attempted to use time (HH:MM:SS) in my query and have not been able to utilize it well. for example instead of just Between Date()-1 and Date() I wanted to do Between Date()-1 05:00 am AND Date() 02:00 am, I have viewed a lot for Date but not much on time and would like a greater understanding of time in queries. I have tried throwing # in a bunch of diffrent ways and even splitting time away or h: Hour([datetime]) in the field.