Time Query

[Mike Chandler]

I have a table that has 2 fields. The first field is
called CALLID and the second field is called TIME. The
Time field is formatted as HH:MM:SS format. For example
17:34:00.

I would like to create a query that will count the number
of CALLID records by grouping the Time field in Half Hour
Intervals.

How do I do that ?

 

[Allen Browne]

Create a calculated field to identify which half-hour each record belongs
to, and group on that.

The calculated field would look like this:
WhichHalfHour: DateDiff("n", #0:00:00#, [CALLID]) \ 30