Returning records between two times

[primagic]

I have a datetime field in a table.

I want to be able to retrieve all records between the hours between 09:00AM And 12:00PM (Midday) on any given date.

What criteria do I write?

I have tried

Between #09:00:00 AM# And #12:00:00 PM#

But returns no records

 

[SkipVought]

Hi,

That's because the Date/Time field has BOTH date & time. Foir instance, right now it is 40574.84268 in North Texas which is 1/31/2011 20:13.

So "any given date" must ALSO be included in some way in your query.

Please post ALL you SQL.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[dhookom]

You can query between the times using
TimeValue([YourDateTimeFieldHere])

Duane
Hook'D on Access
MS Access MVP