How do I consolidate like items to one line.

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

Guest

I am working on a freight report. In the report I get the bottom line cost
for all vendors in the grouping, but the report is 300 pages because it also
lists every line with the same vendor name. Is there a way to suppress all
like vendors to one line?

Ex. of current

Johnson and Johnson $10
Johnson and Johnson $10
Johnson and Johnson $10

Ex. of idea

Johnson and Johnson $30
 
Hi,

In design view remove the controls from the detail section
of your report and shrink (drag) the detail section to 0
height. The Sum and count functions in the group footer
will still work. Your report should be a bit smaller after
this.

HTH

Terry
 
Back
Top