Report every 30mins

[Mary]

I have a data for all calls we received every day with date and time stamp
and from that data i'm wondering if i can have report for how many call we
have received every half an hour start from 9am to 6pm every day.
Can someboday help me with this?? thanks

 

[Steve Schapel]

Mary,

I would set up a system of numbering the 30 min time periods, so
9:00-9:29 is period 1, 9:30-9:59 is period 2, etc.

Then, make a query and you can put a calculated field like this...
TimePeriod: Hour([YourStamp])-9+IIf(Minute([YourStamp])<30,1,2)

Then just make it a Totals query, group by this calculated field, and
Count the records. So, the SQL view of such a query will look something
like this...
SELECT Int([YourStamp]) As TheDate,
Hour([YourStamp])-9+IIf(Minute([YourStamp])<30,1,2) AS TimePeriod,
Count([CallID]) AS NumberOFCalls
FROM YourTable
WHERE [YourStamp] ... <your date criteria>
GROUP BY Int([YourStamp]),
Hour([YourStamp])-9+IIf(Minute([YourStamp])<30,1,2)