Nov 7 2005, 04:56 PM
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.
Nov 7 2005, 05:53 PM
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.