Cumulative sum

[hals_left]

Hi,

Can anyone help with an access report to show the cumalative work
days.
Below is what Im trying to achive, although the SQL is invalid.

Im trying to calculate on-the-fly a sum for each record based on the
records before that appear in the results - if that makes sense!

Thanks
hals_left

SELECT DueDate as foo, WorkDays, (SELECT Sum(WorkDays) as
CumulativeDays FROM Mods WHERE DuesDate <=foo) FROM Mods


Due Date WorkDays Cumulative Days
31/08/04 12 12
30/09/04 45 57
31/10/04 60 117

 

[Jeff Boyce]

Take a look in Access HELP under the "running sum" property.