Access - Subreport totals

A

amw0830

I have a report with about 5 or 6 sub reports. In the main report
footer, I am totaling various pieces of data with no problem
EXCEPT...the results that I'm getting, although mathematically
correct, are for the next record.

Specifically, this is a benefit statement report but, the footer is
showing the benefit totals for the next employee rather than the
current employee.
 
A

Allen Browne

What "footer" are you using?

Is this:
a) Page Footer - won't work.
b) Report Footer - shows once at end of all sections, and totals all.
c) Group Footer - totals items since the group header changed.

If that doesn't help, please include more info, including your version of
Access and service pack (shown under Help | About.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum function in report not working properly 5
Return Totals for multiple categories from a subreport 4
Report Totals 2
Error in totals when no data in subreport 1
subreport/report total question 5
Totals getting doubles 4
Calculate Subreport totals in a main report Group footer 3
Subreport Summary 1

Top