I tried using this query: Running Total: CDbl(DSum("[Cost_Replacement]","Cost of Replacement","[RR_Pipe_ID]<=" & [RR_Pipe_ID] & "")) This above query provides the sum not the difference.
My target is to calculate the cumulative difference of the Cost_Replacement column.
Asked
Active
Viewed 17 times
1

Alence Poudel
- 11
- 1