Posting a "to date" (cumulative) amount

[djmurphy58]

Here's what I am trying to do: On my report I want Access to calculate a cumulative amount-

I want a report like this (sample data)

DATE QTY HOURS CUMULATIVE_QTY CUMULATIVE_HOURS
Nov1 50 8 50 8
Nov2 70 10 120 18
Nov3 60 12 180 30
Nov4 90 14 270 44

So you can see what I'm trying to do - I want columns for cumulative hours and cumulative quantity. I need these columns to track costs for a construction project on a daily basis.

Can this be done?

Thank you
Dennis

 

[djmurphy58]

Nevermind I figured it out.....I have to use RunningSum.