var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Count [TblName.Detailrecs] of main report in sub report
I have one txtfield in the detail section of the main report that I would link to total in the subReport.
I have a sub report based on a calculations query.
I need to =count(txtfield) in the main report and place that in the report footer of the subReport.
I've found this is klind of tricky!
This is what I've tried but it fails.
In the Control Source =Count(tblMain.xtxField)
Thanks . . . Rick
In my original calculation query I place a field with a count on it.
Then in my subReport I just placed CountName field in the subreport.