FIlter out certain times 1

[rockiwood]

I am building a query for a table that has datetimedown and datetimeup. They are in the format of #6/27/2002 3:00:54 AM#.

I want to filter out any time(hours) that are between 3AM and 7AM in the datetimedown field.

I have created a field in the query:
DateTimeDownHours: ([flddateTimeDown])
and formatted it formatted it as Long Time. I have tried several filters and I can't (don't know how to) get it to work.

Is there a way that these can be filtered out in a query?
I hope this enough information.

Thanks for any help in advance!!

Jerry

 

[PHV]

SQL code snippet:
WHERE TimeValue(flddateTimeDown) Between #03:00:00# And #07:00:00#

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[rockiwood]

Thanks PHV.

I'll do that today...

Jerry