Summing main report and three sub reports

Summing main report and three sub reports

Post by M.Garz » Sat, 10 Mar 2007 07:51:46


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
 
 
 

Summing main report and three sub reports

Post by RHVhbmUgSG » Sat, 10 Mar 2007 12:00:02

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

 
 
 

Summing main report and three sub reports

Post by M.Garz » Sun, 11 Mar 2007 05:13:48

On Mar 8, 9:00 pm, Duane Hookom < XXXX@XXXXX.COM >



Ok, that worked! Thanks!!
Maria