Hi,
I need to build a query to display sales by hour range.
In short, the table has two significant columns for the calculation:
Sales_Total and date, date column is datetime type and always has full time/date information. ie 09/30/2004 02:06:50 a.m.
There are several other columns, but they will be used for filtering.
The result I need is:
Time Total
----------- --------
9:00 - 9:59 11111.00
10:00-10:59 22222.00
11:00-11:59 0.00 (I need to display 0 if no sales were made).
...
20:00-21:00 33333.00
Total 66666.00
Thank you all in advance.
Regards
I need to build a query to display sales by hour range.
In short, the table has two significant columns for the calculation:
Sales_Total and date, date column is datetime type and always has full time/date information. ie 09/30/2004 02:06:50 a.m.
There are several other columns, but they will be used for filtering.
The result I need is:
Time Total
----------- --------
9:00 - 9:59 11111.00
10:00-10:59 22222.00
11:00-11:59 0.00 (I need to display 0 if no sales were made).
...
20:00-21:00 33333.00
Total 66666.00
Thank you all in advance.
Regards