totals of subreport

M

Michel Peeters

I have a mainreport with 2 subreports.

The subreports are based on a Totalquery.
In the detailsection from each subreport I have a txtbox named "txtPcs" -
recordsource "= [SumOfPcs]"
In the reportfooter (visible = no) I have a txtbox named : "txtSumPcs" -
recordsource "=Sum([SumOfPcs])"
When I open the subreport without the mainreport this grandtotal works ok.

I want in the mainreport the total from the subreportfooter and I created a
txtbox in the reportfooter from the mainreport with controlsource:
= rptSubreport.Report!txtSumPcs.
But what I get is the [SumOfPcs] from the last record from the subreport.

I tried with running sum but could not solve the problem.
Pse help.

Michel
 
Top