Adding SUM to sub-reports

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

Guest

I am trying to add a sum to each of my report pages. Each page is a different
client. There are two sub-reports with a column of premium dollar figures
that that I wish to SUM.

I added a footer to one of the sub-reports, then added the text box [AB|] to
the footer of the report.
In the ControlSource property box, I typed: =Sum([IPROJ_PREM]).

Two things: 1) it doesn't sum up the figures and 2) it shows up way down the
page when previewed and not at all in the report itself. Any ideas? Thanks
in advance.
 
Nevermind. I figured it out. I just added the SUMs to the main report in the
footers not in the sub reports. WHEW! and Eureka!
 
Back
Top