Totals, subtotals, grouping ???

[atadbitslow]

I have a report that has two footers--in the first footer, I have a calculated field that counts the records by discipline. In the second footer, I need to sum the record counts into one total.

I can't use the sum function and use the field name of the counts in the first footer, so how can I do that??

Thanks!

 

[atadbitslow]

Got it--used another text box and set the runningsum property, then referred to that text box.....so confusing!