group by

[zezo2021]

friends
as attached image
if the client duplicated can I merge the fields value with "," for each field in one row as the sample attached

 

[Minty]

You can using a function such as the one below

Code Snippets

 

[zezo2021]

Please check this DB Sample with the function
the function is great for stack over flow

but the query give me an empty row

Can you pls fix the error

 

[zezo2021]

thanks, friends
if find the solution with qoutation
-------------
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;
-----------