without running a query for each month.
Ex:
ProdDate Volume
2011-04 1234
2011-05 0123
2011-06 5678
2011-06 9012
2011-06 3456
2011-06 7890
2011-07 1234
2011-07 5678
So on and so on.
I understand how to get totals for the whole year, but was wondering if there's a faster way to get monthly totals then to running a query for 2011-06, 2011-07, 2011-08 etc. Thanks!
Ex:
ProdDate Volume
2011-04 1234
2011-05 0123
2011-06 5678
2011-06 9012
2011-06 3456
2011-06 7890
2011-07 1234
2011-07 5678
So on and so on.
I understand how to get totals for the whole year, but was wondering if there's a faster way to get monthly totals then to running a query for 2011-06, 2011-07, 2011-08 etc. Thanks!
Need monthly totals
0 commentaires:
Enregistrer un commentaire