Report for two different counts on one field 1

[ferrysailor]

I have a table with a field that tracks the time (0-2400) events happen by workers. I am trying to make a report showing the 6AM to 6PM shift (Day) and the 6PM to 6AM shift (night).

I have tried using two queries. One is – [count on the Field “Where “ the event time is >=600 and <1800 (Day shift)] and the other query is –[count on the Field “Where “ the event time is, <600 and >=2400(night shift).
Each query gives the correct answer for their time period. When I try to create a report using the results of both queries I get the same number for both. How can I get these two results correctly presented in one report?
Thanks for any help you can supply

 

[PaulBricker]

Create a query in the first column put
MyShift:IIf(Time >600 and Time < 1800,&quot;DayShift&quot;,&quot;NightShift&quot
Then add your Time field to the next column
Turn on the Totals
GroupBy MyShift and Count the Time field. This should return two records with a count of each.

I think.

Paul