combining duplicate entry's 1

[ironj32]

this is probably easy but i cannot figure this out for some reason.

i have a table (tblDescription) with two fields: "barcode" & "additional description"

there are some duplicate records that have the same "barcode", but different "additional description". is there a way to combine the two different descriptions into one.

ie: barcode description
1300 orange
1300 big

would like to be: barcode description
1300 orange big

thanks a lot for your help!

 

[PHV]

No more than TWO duplicates ?
SELECT barcode, Trim(Min([additional description]) & ' ' & Max([additional description])) AS description
FROM tblDescription
GROUP BY barcode

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

 

[ironj32]

Thanks PHV...exactly what i needed.