Access running total query by month

[Tcurtis]

I am trying to make a running totals query by month. I have the prices of jobs by day and would like those to be totaled up to a monthly total and then do a running total as the year progresses.
Month Monthly Price Running Total
Jan. - $1,000.00 $1,000.00
Feb. - $500.00 $1,500.00
Mar - $600.00 $2,100.00 ------ etc.

I have tried a couple of methods form the MS website but they do not work for me. Can access do this in a query?

Thanks

 

[ranman256]

Yes, but it cant be done in 1 query simply, 'cause they add 2 different things.
But check : How to create a running totals query in Microsoft Access

 

[Tcurtis]

I tried this in the example they gave me but it did not work, kept getting an error in the northwind database. I also tried a couple of other ideas from people but they did not work either. Kind of at a loss at this point.

 

[ranman256]

Another method I use it to put my data in a 'report' table
Run query 1 ...to append the [total] field would show the sum / month column
Run query 2 ...summs each month by month and posts to the RunTotal column
Query 3 shows this 'report' table.