Seperate time field by work shifts

[Guest]

I'm trying to create a report (thus starting with a query) that counts the
volume of patients on each shift. If the shifts are 7 a.m. - 2:59 p.m., 3
p.m. - 10:59 p.m. and 11 p.m. - 6:59 a.m. and a patient came in at 8 a.m., I
want to count 1 for shift #1 and so on for all patients. I'm assuming I need
to create either 1 expression in a query to put in the shift name or number
and then add up those names in the report or else create 3 expressions for
each shift and put in a 1 in whichever bucket it belongs in. I'm lost as to
what to put in the expression to get what I need. Can you please help? I'm
guessing this would be helpful info for others.

 

[Amy Blankenship]

What is the design of the table(s) you are trying to query?

 

[Guest]

Not sure what you're asking for. The field I'm basing this on is simply a
short time field.