Subreport total on main report

  • Thread starter Thread starter Darrell Cyphers
  • Start date Start date
D

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?
 
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?
Click to expand...

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
 
Back
Top