Question

  • Creator
    Topic
  • #2213558

    count records between a specific time range

    Locked

    by acqanal ·

    I have a table with an “Admit_Time” column. I need to count the records for 3 specific time ranges a) >= 00h and <= 0700h, b) > 0700h and <= 1700h, c) >1700h and <= 2400h. I tried to created a query with using the criteria >#00:00:00 AM# And <=#07:00:00 AM# in the 'Admit_Time' field but Access won't accept the 00:00:00 AM. It kept replacing it with 12:00:00 AM. If there is a better way to accomplish what I am trying to do, I would appreciate your help. Thanks.

All Answers

Viewing 1 reply thread