summing up a field in a Sub-Report

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

Guest

Access 2003

I have a main report that contains a sub-report in the Detail section of the
main report.

I would like to sum up a field in the Sub-Report and display it in the foot
of the main report

I simply added the following in the Control Source of the Text Box that
resides in the footer:
=Sum(rptCostSavings_Detail.Report!CostSavings)

rptCostSavings_Detail is my Sub-Report.

This is not working.

Can this be done?
 
Try this

In the SubReport report footer, create a text field that will do the sum,
and set it to visible False

=Sum(CostSavings)

On the main report refer to the new text field

=rptCostSavings_Detail.Report!NewFieldName
 
Back
Top