Multiple Record Query

Any help would be much appreciated on the following query - i don't have a clue where to start!!!

I have a table where multiple records have the same product part number.

e.g.

part_no          description
TM611TXV         Line one of text,
TM611TXV         Line two of text,
TM611TXV         Line three of text,
TM611TXV         Line four of text,

I want to take each record with the same part number and concatenate them into one record which is returned from the query.

resulting in:

part_no          description
TM611TXV         Line one of text, Line two of text, Line three
                 of text, Line four of text

The only problem is that there could be 1 or 20+ records that need to be concatenated - it needs to work it out on the fly.

Thanks for your time on this matter, Nick Received on Mon Jan 07 2002 - 06:15:01 CST