Results 1 to 2 of 2

Thread: Query Help

  1. #1
    Join Date
    Dec 2005

    Unanswered: Query Help

    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.

    What am I missing?

  2. #2
    Join Date
    May 2004
    New York State
    What happens when you use criteria
    <#01:00:00 am#

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts