Query for Specific 24 hour time period

[esh112288]

Hello,



I'm looking to write a query that, when run, automatically pulls all records created between 6:00am yesterday and 6:00am today. All records do have a date/timestamp field that is populated when the record is created. I currently have:

Between Date()-1 and Date()

This does not cover the 6am piece of the query.

Thanks in advance.

[pbaldy]

Try

Between Date()-1 & " 6:00am" And Date() & " 6:00am"