Sales By Hour

[DS]

I want to run a report for sales by hour. I would have a heading such as...

1:00 pm to 2:00 pm
ID 1 $2.00
ID 3 $4.00
Sum $6.00


2:00 pm to 3:00 pm
ID 7 $1.00
ID 8 $9.00
Sum $10.00

How would I do this?

Thanks
DS

 

[Allen Browne]

Presumably you have a date/time field where you recorded the date and time
of the sale?

If so, you can create a report for your table. In report design view, open
the Sorting'n'Grouping dialog (View menu.)
Choose the date/time field, and in the lower pane of the dialog, set:
the period to Hour
the group header to Yes
the group footer to Yes

In the new group header, place a text box, and set its Control Source
property to:
=DatePart("h",[SaleDateTime])
substituting your field name.

In the group footer section, place a text box and set its Control Source to:
=Sum([Amount])
substituting your field name.

 

[DS]

Worked great!
Thanks Allen
DS

Presumably you have a date/time field where you recorded the date and time
of the sale?

If so, you can create a report for your table. In report design view, open
the Sorting'n'Grouping dialog (View menu.)
Choose the date/time field, and in the lower pane of the dialog, set:
the period to Hour
the group header to Yes
the group footer to Yes

In the new group header, place a text box, and set its Control Source
property to:
=DatePart("h",[SaleDateTime])
substituting your field name.

In the group footer section, place a text box and set its Control Source
to:
=Sum([Amount])
substituting your field name.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I want to run a report for sales by hour. I would have a heading such
as...

1:00 pm to 2:00 pm
ID 1 $2.00
ID 3 $4.00
Sum $6.00


2:00 pm to 3:00 pm
ID 7 $1.00
ID 8 $9.00
Sum $10.00