Cumulative Total

[Ciaran]

I want to graph cumulative totals. I have a query with week numbers 1 to 18 with the number of bugs opened during that week.

I want to do a cumulative total of opened bugs which I can then use to draw a graph (ogive)

I'm trying to do a query using DSum, but cant get it working. Any help would be grealy appreciated.

Ciaran

 

[Tiro Cupidus]

If you want an unrestricted total, you should be able to use Sum([number of bugs]).