I am trying to calculate appts per hour

[smatalone]

Hello,

I am currently working for a scheduling service that uses access to book appts for real estate agents. The query that was setup before is corupt and does not work. I was wondering how do i create 2 queries. 1st query how do i find the total number of appts booked per hour on different days? The other query i would like to calculate is the number of appts per employee per hour then find the total number of appt on different days. The table has the following data

Showing Agent (the person booking the appt)
Created By(the empolyee that took the appt)
Created(the time the appt was created)

any help would be appricated,

sam

 

[PaulBricker]

Something like this will get you the count of appointments
per ShowingAgent per Day per Hour

SELECT [TableA].[ShowingAgent], [TableA].[DateField], DatePart("h",[TimeField]) AS MyHour, Count([TableA].[ShowingAgent]) AS [CountOfShowingAgent]
FROM [Work Orders]
GROUP BY [TableA].[ShowingAgent],[TableA].[DateField], DatePart("h",[TimeField]);

Paul

 

[PaulBricker]

Sorry, the line
FROM [Work Orders]
should read
FROM [TableA]

The phone was ringing as I was posting this.

Paul