Merge rows via SQL

[dax1]

Hello

I have a table made up of 3 columns, these being

REP = Report Number
LINE = Line Number in the report
TXT = Text


My table has some 2000 records and I would like to group it by report number (about 336 reports in all). This requires that I merge (concatonate) the TXT field

Ex:

REP LINE TXT
122 01 Text of report
122 02 Cost distribution
122 03 annual analysis

I would like to return an SQL query that gives me the following

REP TXT
122 Text of report Cost distribution annual analysis

My Union select query does not return the results merged it always returns the 1st & 3rd columns as originally shown.

Any advice would be kindly appreciated. Thank you in advance

Dax1

 

[PHV]

Have a look here:

http://www.tek-tips.com/faqs.cfm?fid=4233

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

 

[dax1]

Worked perfectly.

Thank you for the help.

Kind regards

Dax1