Query to create an incremental 30 min report based off date/time

[TheEnigma]

I currently have a query that shows times that call centre representatives take calls. The information comes straight off of our PABX (phone server).

The query needs to run so that it will show me a total of calls for each half an hour on a particular day.

 

[hermanlaksko]

I assume that you have a date/time field in this data from the pabx.

you need to create a crostabed query and sort on this date/time field fx. Expr1: Format([Date/time];"hh&quot
Will this help ?