Need some guidance on a update query. I have a field (delivery) for the time the load must be delivered. I have a field (transit) that shows how many hours it takes to get there. I can create a calculated field in the query to show when to ship by using DateAdd("h",-[transit],[delivery]). This shows me when to ship the loads.
However, when I go to the criteria line and try to set up to find any load needing to ship at midnight (without criteria I can see several that do), I enter #12:00:00 AM# into the criteria line but it will not pull up the midnight records. Yet when I remove the criteria, I can see them with no issue.