Summing a value in a report with a value in a subreport

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a report that is grouped by a field called Type. There are two
values in type which are Existing Customers and New Customers. There is a
"Type" header that has each value and a "Type Footer" that has the sum of
each category. There is then the Grand Total which sums these two and is in
the Report footer. I have a subreport that also appears in the report
footer. It is also grouped by Type with existing and new customers and a
Grand Total. I need to keep them separate because they query different
things. I want to be able to sum the Existing Customers total from the main
report to the Existing Customers totals from the subreport. I then want to
sum the New customers totals from the main report to the existing customers
total on the sub report and then I want to sum both Grand Totals. Can anyone
help?

Chuck
 
First you need to get the subreport total back onto the main report. See:
Bring the total from a subreport onto a main report
at:
http://allenbrowne.com/casu-18.html

You can then add the two text boxes by setting the Control Source of another
one to:
=[Text0] + [Text2]
That won't work if either is null, so you probably want to use:
=Nz([Text0],0) + Nz([Text2],0)
 
Back
Top