Hi all,
My aim is to get the total value of orders and the total quantity of orders for each month to appear like so:
Total Value Total Qty Month
2000 100 01/2011
3500 200 02/2011
1000 80 03/2011
Etc…
So far I have managed this by performing a query in two steps.
As the original data doesn’t have a quantity field, the first query counts for each month the individual order numbers, their value and the qty:
Order Number Value Count Month
0125 100 5 01/2011
0152 80 2 01/2011
6845 250 3 02/2011
Etc…
I then run a second query from the first to sum value and count and group and group by month which appear as above:
Total Value Total Qty Month
2000 100 01/2011
3500 200 02/2011
1000 80 03/2011
Etc…
If you can help please reply with design view instructions as opposed to code as I’m not quite at that stage just yet!
Many thanks,
Adele x