Cumulative totals - Weekly

[AccessNewbie2007]

Hi, I have a report with basic output on daily basis + a weekly summary.

example:

Date - Ref - Total - Total 2
01/01/2010 - a - 1 - 2
02/01/2010 - b- 2 - 3
03/01/2010 - c - 3 - 4
04/01/2010 - d - 4 - 4
05/01/2010 - e - 5 - 5
06/01/2010 - f - 6 - 6
07/01/2010 - g - 7 - 7

and in the summary I have:
Sum Of Total: 28
Sum Of Total2: 31

how can I add a cumulative sum of each values, meaning the next week I must have the sum of total + the cumulative previous totals.

thanks

 

[AccessNewbie2007]

any help pls

 

[ajetrumpet]

newb,

I have an example of a running total in a query in the FAQ section of this website, but other than that I don't know how to do it. Vertical referencing is a pain in the butt, and probably impossible with this program.

I DID figure this out, but it is slow as a seven year itch. if you find a better way, please post to the FAQ !!!

 

[AccessNewbie2007]

I found it and it is working properly and I would like to share it

details at: http://support.microsoft.com/kb/290136
Method 2