Sum of report in reports

[red91]

In one report I summed up multiple DETAILS to come up with a total cost of the product in the footer. I needed the total to show up on other reports so I made a copy of the report that calculates the total and shrunk everything except the total cost. Next I drug a copy of that report and used it in the details section of the other reports that required it. Works good, but I don't think that I can find the sum of a bunch of reports in a report. Is there a better way to use a sum in one report as a detail in another. This is driving me nuts!!!!!!!!!!

 

[yellow]

I'm not sure I fully understand but why not do the sum in a query and use dlookup to show the value in the footer of your first report and also in the detail of the 2nd report.