Combining Rows

[AmazingCLK]

Hey Everyone, Im new here and a fairly new user to Microsoft Access. My question is; Is there a way to combine identical rows in a report? See below for my
example.

5 24683 65 Active FORTUNE 030 11/17/2005 11/17/2005 Seal Retaining
5 24683 65 Active FORTUNE 030 11/17/2005 11/17/2005 Seal Retaining
5 24683 65 Active FORTUNE 030 11/17/2005 11/17/2005 Seal Retaining
5 24683 65 Active FORTUNE 030 11/17/2005 11/17/2005 Seal Retaining
5 24683 65 Active FORTUNE 030 11/17/2005 11/17/2005 Seal Retaining
5 24683 65 Active FORTUNE 030 11/17/2005 11/17/2005 Seal Retaining
5 24683 65 Active FORTUNE 030 11/17/2005 11/17/2005 Seal Retaining



Any help is greatly appreciated

Thanks
Mike

 

[AlexMidd]

Select the "Group By" button (Greek Sigma symbol in toolbar) in the query for the report. This will put any identical rows into one record.

Have fun! )

Alex Middleton

 

[PHV]

Or use the DISTINCT predicate in your SQL code.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886