Does anyone have some sort of Weekly by hour report What i would like to see is a whole week day by day and total sales for each hour.
09:00 M T W T F S S 10:00 X X 11:00 X XThanks for help
Robert
- posted
14 years ago
Weekly by hour report
Loading thread data ...
- Vote on answer
- posted
14 years ago
Hi Robert
We have a report that will give you exactly that. This report is available > Does anyone have some sort of Weekly by hour report
- Vote on answer
- posted
14 years ago
You can do this with a query and then run a pivot table in excel:
select left(time,12) date, right(left(time,14),2)+':00 '+right(left(time,19),2) hour, sum(quantity*price) total from [transacti> Does anyone have some sort of Weekly by hour report
- Vote on answer
- posted
14 years ago