Would like to know the number of calls per hour

[Rene1024]

Hello,

I have a table that logs calls made to hour hotline.

I have a table with the caller's information along with a field for date of the call and time of the call.

I would like to design a query that tells me proximately how many calls are received per hour, per specified date. This would help determine the busiest time of day and staff accordingly.

How can I accomplish this?

Rgds.

Rene

 

[genomon]

SELECT COUNT(CallsReceived) FROM YourTable WHERE date = #" & YourDate & "#";

"Rome did not create a great empire by having meetings, they did it by killing all those who opposed them."