count records between a specific time rangeLocked
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.