track ordersd by time

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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]
 
Back
Top