Running Sum by Date - Help

[hackfifi]

Hello Everyone,



I know "Running Sum Query" forums have been beaten to death on the net, but I am stuck developing this query, and I would appreciate any help. Please see attachment.

I just need to get a simple Running Sum of each month, BUT it does not have to reset after the year. Using MS Access Help , i tried using a RUNNING SUM example, but the value resets at the end of the year. I just need a continously running sum query, with no reset. The problem is i do not have a "Unique ID". I only have a date.

Thanks again!

Cheers

[hackfifi]

Hey Guys...

After doing more research, i got around to make it work - but not 100%.

The first value comes up as error. Please see attachment and advise. Thanks.

[thhui]

Use =iserror(expr), 0, expr) to elinimate the #error message.