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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Totaling Multiple Subreports 5
subreport totals 1
subreport/report total question 5
SubReport Field / Report Field = % 1
Subreport Linking 3
Return Totals for multiple categories from a subreport 4
Subreport Summary 1
SynNeed to account for null values in subreports 2

Back
Top