Full Version: Using summary/average functions in a report design
UtterAccess Discussion Forums > Microsoft® Access > Access Reports
ldg05
How can I move the summaries and or averages for different groups in my report? They only seem to calculate correctly while in the header or footer for that specific group. I want some of them to show up on every page of the report, not just in the header or footer for that group. Like a TOTAL ORGANIZATIONAL SUMMARY for all at the top of each page.
fredrisg
One solution is to create a subreport that just calcs the totals and displays them at the top of each page.

The subrpt qry should be similar to the main report qry but a totals qry based on the same critieria.

You could place this subrpt on each page header.

The only issue might be a time hit . . . so another option would be to run the subrpt once and then store the values for printing on each page.

Steve
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.