Calculating within Subreports

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

packetscanner - 14 Feb 2005 17:13 GMT

I have a report with no control source that just displays 6 subreports. I
would like to get a sum of a field within each of those subreports and
display it in the report footer of the main report. Can anyone help me?

Reply to this Message

Marshall Barton - 15 Feb 2005 04:58 GMT

>I have a report with no control source that just displays 6 subreports. I
>would like to get a sum of a field within each of those subreports and
>display it in the report footer of the main report. Can anyone help me?

Each subreport has to calculate it's own totals in its
report footer.

Then the main report can refer to those totals in this kind
of expression:

=subreporta.Report.totala + subreportb.Report.totalb + ...

Signature

Marsh
MVP [MS Access]

Reply to this Message