Rolling Sum

M

michael c

I have a query with columns like so:

InvoiceDate InvoiceMonth InvoiceAmount
01/05/03 1 50.00
02/12/03 2 400.00
02/15/03 2 100.00
08/01/03 8 300.00

I'm trying to create a rolling sum like so:

InvoiceMonth InvoiceAmount
1 50.00
2 550.00
8 850.00

Any suggestions would be great. Thanks!
 
A

Andrew

Michael, I am trying to do the same without much joy, what was the article
you found, if you don't mind me asking.

Andy
 
S

StCyrM

Hi

If you would like an example of how this is done, send me an email.

Best regards

Maurice
 
Top