Create a running sum in detail section of report

[Susanne45]

I created a report based on a query that counted each occurrence of Problem by Year, Month. The report gives me the correct total for month and correct total for YTD however, I can not figure out the expression for YTD Total for the detail section. Any suggestions would be greatly appreciated!

Month Problem Desc Month Tot YTD Tot

Jan
Detail Incorrect Freight 1 ? (1)
Detail Shipping Error 1 ? (1)
Month Footer Tot 2 2

Feb
Detail Incorrect Freight 3 ? (4)
Detail Shipping Error 2 ? (3)
Month Footer Tot 5 7

Detail - Month Tot CountOfType Of Problem
Detail - YTD Tot ?????????????????
Month Footer - Month Tot =Sum([CountOfType Of Problem])
Month Footer - YTD Tot =([Sum Of CountOfType Of Problem])


Thanks,

Susanne

 

[pdldavis]

Hi, you might try changing your text box data Running Sum to Over All for YTD totals. You can also do your totals in the report footer.

Hope that helps.