track ordersd by time

[Guest]

I'm trying to create a query that counts the number of orders recived hourly
for any given day, week, month or year. The end result is to try to track the
busiest hours of the day. Can someone help me with the easiest way to query
the database to return orders placed hourly?
Any help greatly appreciated.
Joe

 

[John W. Vinson]

I'm trying to create a query that counts the number of orders recived hourly
for any given day, week, month or year. The end result is to try to track the
busiest hours of the day. Can someone help me with the easiest way to query
the database to return orders placed hourly?
Any help greatly appreciated.
Joe

Create a Query based on the table. Put in it a calculated field

TheHour: Hour([datetimefield])

Add this and some other non-null field from the table (the primary key is a
good choice); change the query to a Totals query. Group By TheHour and Count
the other field.

John W. Vinson [MVP]