Figure hours

[skwilliams]

I have a query in which I need to display just the data that was entered from 9:00 p.m. the previous day until now. There is a date/time field called "QtyTime".

Thanks.

 

[Jon K]

>=Date()-1+#9:00:00 PM#

This criteria for the [QtyTime] field will return the records since 9:00 p.m. the previous day.
.

 

[skwilliams]

That worked!

Thanks.