Summary report

[Jonathan Blitz]

I need to produce a summary report within a detailed report.

What I have is a report of commissions to be paid to dealers for sales.
The report produces details for each dealer of every sale that they made
plus the commission to be received.
At the end of each dealer there is a total of all the commission.

What I need to add is a sumamry page of one line per dealer that contains
the data from the totals calculated.
In this way, I get a page (or pages) with details of the total commission
paid to each dealer.

Can I do this within one report or will I have to produce a second report?

--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."

 

[Larry Linson]

You could create a simple report based on a Totals Query and include it in a
Subreport Control in the Report Footer of the Report you described. That
would seem to me to be the simplest, easiest, and probably most efficient
approach.

Larry Linson
Microsoft Access MVP