D
Dave T
Can anyone out there help me? I am creating a very basic
query to calculate the amount of money spent on spare
parts each month in 2003. What I would like to add is
another column which shows the cumulative total (or
running sum) over the year (i.e Jan, Jan+Feb, Jan+Feb+Mar
etc...)
I know this can be done easily in a report, but would
like to use the query as I would like to create a graph
to go on the final report.
All suggestions welcome.
Dave
query to calculate the amount of money spent on spare
parts each month in 2003. What I would like to add is
another column which shows the cumulative total (or
running sum) over the year (i.e Jan, Jan+Feb, Jan+Feb+Mar
etc...)
I know this can be done easily in a report, but would
like to use the query as I would like to create a graph
to go on the final report.
All suggestions welcome.
Dave