Summing multiple subreports into main report

G

Guest

I have read through the replies of earlier requests on this issue and could
not resolve my issue. I am a self taught access user (but use it daily and
build semi complex db's) so if there is an easier way to accomplish this,
please let me know.

I have 5 subreports that have a subtotal in the group footer of each
subreport. I am trying to get a grand total of all 5 of those in my main
report. In each of the subreports, the expression
=sum([bonus_accrual_impact]) is in the footer of each report.

I have tried the unbound txt box in the detail and footer sections, but I
always come up with an error. The txt box is set up as a running sum
currently.

If anyone can help me with this, I would greatly appreciate it.
 
G

Guest

Are you using a field or fields to Link Master/Child? If so, I would create
totals query that calculate the subtotals from each subreport based grouped
on the field(s) used to link. You could then add the totals queries to your
main report's record source to make the totals available.
 

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

Top