Totals from a subreport

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Main Report with the following fields: ID, DATE, NAME
My Sub Report has the following fields: ID, TRUCKAMT, PAYROLLAMT.
They are linked by an ID field (which turns out to be date driven).
I can get the totals for TRUCKAMT & PAYROLL AMOUNT by date. But I need to
have the totals for those same two fields for the entire report.

Any suggestions are greatly appreciated.
 
Create a group by date, in the group footer add text boxes with their control
sources like
=sum([TRUCKAMT]) and the other with =sum([PAYROLL AMOUNT])

copy these 2 boxes in the report footer section
 
Back
Top