RunningSum not totaling columns with nz()

[storl2]

Hi all,

I searched the forum, but couldn't find an answer to my question.

I have a report showing community service hours and donations for the year that pulls from several tables. The tables often have no data for donations or hours for a particular month, so the source query for the report uses nz() to return zero where there are no data.

The report has two columns whose source query uses the nz() function to return a zero if the record for that month is null. The columns sum at the footer with no problem, but when I try to add a column that is a running sum of the nz() columns, it just shows me the same values. The runningsum text box is in the detail section, along with the other text boxes, and is set to running sum over group. I have several other runningsum text boxes in the same report that work fine, so the only thing I can think that is different is the nz() that the non-functioning columns use. Any help would be greatly appreciated

 

[hymn]

have a look at
thread703-916355

instead of sum

Hope this helps
Hymn