Running Sum - it doesn't like zero

[Xeon007]

I have a slight problem with a running sum on a report.

If any of the records in the report have a zero in the field that is summed, then Access will just reset the sum.

So, if the three values are 10, 20 and 30 (in that order), the value is 60 but if it was 10, 20 and 0 the value is 0.

Why is this and can anyone help?

 

[CATT1]

How did you get the running sum? I tested this with a report I needed a running sum in and added a line with an amount of -0- and it still calculated the right totals. The steps I followed were these;

1) Open the report in design view.
2) Add a text box control to the detail section of the report.
3) Right click the text box and choose "Properties" to open the properties window.
4) Click the data tab, and in the Control Source property, enter the name of the field you want to sum (example - "amount")
5) In the running sum property, choose either Over All, if you want to sum to keep running total throughout the entire report, or Over Group, if you want the running sum to reset to zero for each group.

Is it possible that the grouping needs to be changed? My report dealt with students, so the grouping was semester.

 

[Xeon007]

I designed it the same way as you. I've managed to get what I wanted using a sum in a continuous form (after a lot of hassle!).

Thanks anyway.