Running Sum in Select Query

  • Thread starter Thread starter Dave T
  • Start date Start date
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Running Sum in Query 1
Running sum that restarts on each group 3
UNION and Crosstab query 5
Choose append field based on criteria 4
Crosstab queries, <> and null values 3
Query SELECT in SELECT? 2
Where are Mod's defined in databases 1
Monthly transactions in query 3

Back
Top