customer count?

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

Guest

I have an access database with specific date and time information for
individual customers.
I need to create a report showing the hourly customer flow by month...how
can I set up the query to do this, without showing each unique time, but
rather the hourly sum of customers per month?
 
You could use a calculated field and group by the field

For instance
Format([YourDateField],"mm h") will return the month number and the hour
number

Or group by
Month([YourDateField])
Hour([YourDateField])

You would use those in a totals query. (See View:Totals in the menu)

Post back with more detail if you need more help.
 
Thanks...that's just what I was looking for!

John Spencer said:
You could use a calculated field and group by the field

For instance
Format([YourDateField],"mm h") will return the month number and the hour
number

Or group by
Month([YourDateField])
Hour([YourDateField])

You would use those in a totals query. (See View:Totals in the menu)

Post back with more detail if you need more help.

bobbygo said:
I have an access database with specific date and time information for
individual customers.
I need to create a report showing the hourly customer flow by month...how
can I set up the query to do this, without showing each unique time, but
rather the hourly sum of customers per month?
Click to expand...
Click to expand...
 
Back
Top