How to show summary totals again at end of detail?

[jetspin]

Hi.

I see how to make group headers visible = false to supress details lines to make only total lines appear in a report for a 'Totals Summary' Report.

But what is a good method to combine a 'Details and Summary' report with a 'Summary Only' report at the end of
the 'Details and Summary' report? I'd like to add this to most of my reports with subtotals.

My client now selects report from switchboard which previews/runs the report. Do I add code after the on click event of this button after the docmd run preview, to make the group headers visible false and run the report again with no preview? This does not sound like the best method.




Fred

 

[dhookom]

Apparently you want to see both details and summary footers with a recap of all the group footers in report footer. If so, you will need to use a subreport in your report footer. The subreport will be based on a totals query.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.