Calculated Field with Running Cummulative Total!

[countingguru]

Dear friends



I need calculated field (in a query) that executes a running cummulative total for three conditions: "="&Project Name, "="&Service and "<="&Date.
I can do it in Excel using SUMIFS(), but have no clue on how its done in Access 2010 !
The "Balance" field should be the end result:


Project Service Date Amount Balance
A Welding 1/1/2012 100 100
A Welding 1/2/2012 120 220
A Wiring 1/3/2012 150 150
B Welding 1/1/2012 103 103
B Painting 1/2/2012 124 124
B Painting 1/3/2012 155 278
C Welding 1/1/2012 106 106
C Wiring 1/2/2012 127 127
C Wiring 1/3/2012 159 286


Thanks !

Al

[John_G]

HI -

MS Access is not Excel, and can't do some of the things Excel does; running totals in a query is one of the things it won't do. Running totals are in reports.

John

[countingguru]

Actually I found my answer, its DSUM(). You can create a DSUM("Amount","tblProject","project="&project) AS Balance. It works.

[geocan2006]

Can you load a sample please?

Thanks

[orange]

geocan,
You have posted a request in a thread that is almost 8 years old!!
I recommend that you create a new thread and provide readers with an overview of your issue/opportunity so they can offer focused feedback.
Good luck.