I have a table of data which contains daily sales achieved by employees I am trying to put together a query that sums each employees sales into weekly totals:
Week1 Week2 Week3 etc.
John 12 7 8 etc.
Paul 6 12 13 etc.
The week runs from Monday to Sunday.
I have seen this achieved before, however I have not been successful in finding the method.
A point in the right direction will be appreciated.
Week1 Week2 Week3 etc.
John 12 7 8 etc.
Paul 6 12 13 etc.
The week runs from Monday to Sunday.
I have seen this achieved before, however I have not been successful in finding the method.
A point in the right direction will be appreciated.
