Time Query

  • Thread starter Thread starter Mike Chandler
  • Start date Start date
M

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 ?
 
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
 
Back
Top