Rolling Sum

  • Thread starter Thread starter michael c
  • Start date Start date
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!
 
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
 
Hi

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

Best regards

Maurice
 
Back
Top