Adding SUM to sub-reports

N

Novice2000

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.
 
N

Novice2000

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top