totals in a report

[binglis]

When my query displays more than one record. The totals at the page footer
are out of sync. The report shows the total for the next record not the
correct total. Can anyone help.
Thanks

 

[Duane Hookom]

Page Footers don't generally allow for any aggregate functions. How are you
putting a total in this section? Can you use the Report or a Group section in
place of the Page Footer?

 

[binglis]

I am printing a list of records that displays a sub report that adds up the
total. The sub report total then is displayed on the page report of the main
report. When I get 5 different records the main report displays correctly and
the total in the sub report displays correctly. Its when I use the total in
the sub report to be displayed at the bottom of each record I get the next
total instead of the right one. When I go to the last record I get the
correct total. Also created a field in the main report and took the value
from the sub report and that worked ok. Tried to copy that to the footer and
again it took the next total. Am I doing something that I shouldnt.
Thanks for your time

 

[Duane Hookom]

When you mention "to the footer", you should provide which footer. 75% of the
time you have a total in a subreport, you can get that total into the record
source of the main report. This allows you to display the total without any
reference to the subreport total.