Combine multiple row's records in one row with MS Access Query? I have a table (name- tbl2) with 21 column but I want to combine multiple rows records in a row by using a unique reference number as below:

Table Field and Records Type



Expected Result:



Please help me to resolve this issue.
Try the below query will solve your problem:

SELECT ID, STUFF(
     (SELECT ', ' + CAST(Item AS VARCHAR(20)) [text]
     FROM TBL12
     WHERE ID = t.ID
     FOR XML PATH(''), TYPE)
    .value('.','NVARCHAR(MAX)'),1,2,' ') Items
FROM TBL12 t
GROUP BY ID


Since you add many tags in the post, I solved in MSSQL using STUFF. 
Working fiddle: http://sqlfiddle.com/#!3/d805d/4