Summing main report and three sub reports

M

M.Garza

Hello, I have a report with three subreports, I cannot figure out how
to or where to add a text box that sums up all four reports. I can
sum two reports but when I get to the third one I get either #Error
or ?Name. I don't understand how I can add the two but not the rest.
Can someone help?

Maria
 
D

Duane Hookom

The easiest method might be to ignore the subreports entirely other than
respecting their record sources and how you want to calculate the values you
would get from the subreports. Build a totals query to calculate each of the
values that you would have expected to pull from the subreport. Then add the
totals queries to the record source of your main report and join the
appropriate fileds. This will make all your values available in your main
report.
 
M

M.Garza

The easiest method might be to ignore the subreports entirely other than
respecting their record sources and how you want to calculate the values you
would get from the subreports. Build a totals query to calculate each of the
values that you would have expected to pull from the subreport. Then add the
totals queries to the record source of your main report and join the
appropriate fileds. This will make all your values available in your main
report.

--
Duane Hookom
Microsoft Access MVP






- Show quoted text -
Click to expand...

Ok, that worked! Thanks!!
Maria
 
Top