Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Create a running sum in detail section of report

Status
Not open for further replies.

Susanne45

Technical User
Sep 26, 2002
4
US
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
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top