G
Guest
I have a database that we are currently using as order tracking. Each order
gets entered on the day it was ordered, and we store an "Order Date" field
with each record. I am trying to come up with a querie that will give me a
'running tally' (possibly as a pivot chart) on how many orders we took in
each month (from when we started through the current month). Is there an
easy way to do this so that we can just re-run the report/querie everytime we
want to look at this data? (I am guessing there is a way to do this, however
it is beyond my scope of expertise). Any help would be greatly appreciated.
gets entered on the day it was ordered, and we store an "Order Date" field
with each record. I am trying to come up with a querie that will give me a
'running tally' (possibly as a pivot chart) on how many orders we took in
each month (from when we started through the current month). Is there an
easy way to do this so that we can just re-run the report/querie everytime we
want to look at this data? (I am guessing there is a way to do this, however
it is beyond my scope of expertise). Any help would be greatly appreciated.