Ms Access Query: Concatenating Rows through a query
concatenation, group-by, ms-access, sql
Solution
You need a function to do the concatenation.
Microsoft Access condense multiple lines in a table
Example using your data:
Select T.ColumnA
, GetList("Select ColumnB From Table1 As T1 Where T1.ColumnA = " & [T].[ColumnA],"",", ") AS ColumnBItems
From Table1 AS T
Group By T.ColumnA;
Problem
Suppose I have table in Ms Access with following information: ``` ColumnA ColumnB 1 abc 1 pqr 1 xyz 2 efg 2 hij 3 asd ``` My question is, how can I concatenate the values in the second column to a row value based on the first column. The query results that I want is as follows: ``` ColumnA ColumnB 1 abc, pqr, xyz 2 efg, hij 3 asd ``` I want to achieve this through a query. Can someone help me attain this?