Multiple Date Query not Working

[wolfm]

Hello:
I have a table 'Truck Runs' and a query 'OT Query'. I want the 'OT Query' to pull the truck runs for a specified time frame, and of those, list only the truck runs delivering before 8:00 am and after 4:30 pm. So, I want my report to count the number of truck runs on overtime (before 8 am and after 4:30 pm)

If I only have the date range in the query, it works fine. But, when I add the overtime column to the query, nothing comes up.
Am I formatting the date criteria correctly, or are the two pieces of information just conflicting with each other?



Attached is a shot of my query. Thank You!!

[orange]

Try putting OR instead of AND in your TimeOfDelivery criteria.

You could also try

Between #4:30:00 PM# and #8:00:00 AM# as the TimeOfDelivery criteria

[June7]

Maybe:

<#8:00:00 AM# Or >#4:30:00 PM#

or

NOT Between #8:00:00 AM# AND #4:30:00 PM#

or

NOT (>#8:00:00 AM# AND <#4:30:00 PM#)


I don't recommend popup input parameters - can't validate input. Should do input on form and reference controls as parameters.

[wolfm]

Thanks to both! Makes a lot of sense, and it worked! It was an instant fix. Thanks Again!

[orange]

Happy to help.