Sales report by the hour

[brnmoore]

This is my first post for this forum and hopefully can get some help with this. I have been searching the internet to find something like I am trying to do , but no luck so here is my post.

I am trying to make End of Day report showing Sales per hour based on the hours of operation our store is open(9am-8pm) plus show # of sales taken by clerks per hour as well.

Ex:

9-10am $100

Blake 12

Kim 16

Ron 4

10-11am $250

Blake 15

Kim 12

Ron 10

and so on.

I have the following fields to work with:

Sales_Order_Number

Sales_Order_Total

Sales_Order_Date

Sales_Order_Time

Clerk_Id

Which way would be the best to produce this? Using a Case or If function? Maybe a sub summary?

Any suggestions would be greatly appreciated.

Thanks

[comment]

A report with sub-summaries by hour and by person should work well here. You need to add a calculation field to calculate a common hour, and two summary fields - one to count the sales and one to sum the amounts.