Rolling Sum

[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!

 

[michael c]

i found an article and got it going. thanks.

 

[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

 

[StCyrM]

Hi

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

Best regards

Maurice