Access - Show Total from Sub-Report

Hi,

I have a main report that contains a sub-report.

I want to show a total for the sub-report in my main report's report footer, but to date haven't been able to do so.

Does anyone know if this is possible and if so how?

Regards

Hi,

Could you try to calculate total in the sub-report itself ans then set
the Control Source property of a textbox in the main report footer
to that "total"?


Regards,
Shurik.

Hi,

Could you try to calculate total in the sub-report itself ans then set
the Control Source property of a textbox in the main report footer
to that "total"?


Regards,
Shurik.

I've done this by calculating the total in the sub-report footer and set it's visible property to false,but all I get is:- #Name?

Even when using the expression builder?

Regards.

Hi,

-in the report footer of your sub-report you calculate the Totals
-in the report footer of the main report you drop a TextBox witht he Control Source set to the Totals


(....=[Child7].[Report]![txtTotals])


Regards,
Shurik.