Summing multiple subreports into main report

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.

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.

--
Duane Hookom
Microsoft Access MVP


"ZombieGeoff" wrote:

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.