Cumulative sum

  • Thread starter Thread starter hals_left
  • Start date Start date
H

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
 
Back
Top