Access - Show Total from Sub-Report

pozzi
12-18-2003, 08:26 AM
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

Shurik12
12-20-2003, 04:15 AM
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.

pozzi
12-22-2003, 07:54 AM
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.

Shurik12
12-24-2003, 03:50 AM
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.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum