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
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