Between Time Query

[jamphan]

What I am trying to do is get the total number of accounts that came in between 8:30 am and 8:00 pm and also the number that came in after 8:00pm and before 8:30 am. I assume I will need to have 2 queries written. I don't have a problem with getting the number between 8:30 am and 8:00pm. My trouble comes with trying to get the number after 8:00pm and before 8:30am. It returns incorrect value. Any help will be much appreciated.

 

[ColinEssex]

a search would have found this thread with useful links and samples

Col

 

[jamphan]

These threads are about getting the number difference in time. I need to just count the number of accounts that came in between time a and time b when the time is between a pm and an am time.

 

[neileg]

Create a Totals query to count the number of records. Set the criteria for the time field to either
Between 8:30am And 8:00pm
or
<8:30am Or >8:00pm
Depending which set of records you want.