Subreport total on main report

[Darrell Cyphers]

I have a report which lists a check request, then the
specific items for which that check will be cut in a
subreport, and I want to list the total of the the specifics
on the main report. How do I show this?

 

[John Vinson]

I have a report which lists a check request, then the
specific items for which that check will be cut in a
subreport, and I want to list the total of the the specifics
on the main report. How do I show this?

Put two textboxes: one in the Footer of the subreport with a control
source of

=Sum([amount])

If this textbox is named txtTot, set the control source of another
textbox on the mainform to

=Me!subreportname.Report!txtTot