customer count?

[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?

 

[John Spencer]

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.

 

[Guest]

Thanks...that's just what I was looking for!

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.

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?