1. Create a query, and type an expression like this into the Field row:
Segment: DateDiff("h", #0:0:0#, [MyHours]) \ 2
substituting your field name for MyHours.
This shows 0 for the first 2-hours of the day, 1 for the next 2, etc.
2. Depress the Total icon on the toolbar (upper sigma icon).
Access adds a Total row to the design grid.
Accept Group By under the calculated field above:
3. Drag the primary key field into the grid.
In the Total row under this field, choose Count.
This gives the count of records per segment of the day.
If you time field actually contains a date as well as a time, use:
Segment: DateDiff("h", #0:0:0#, TimeValue([MyHours])) \ 2
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://www.yqcomputer.com/
Reply to group, rather than allenbrowne at mvps dot org.