help urgent

[red fox]

hi
my problem is i need query code for
Concatenate Column Values from Multiple Rows into a Single row with Access
like this
Last First Code
------- --------- ----
Lesand Danny 1
Lesand Danny 2
Lesand Danny 3
Benedi Eric 7
Benedi Eric 14

Result should look like:

Last First Codes
------- --------- -----
Lesand Danny 1,2,3
Benedi Eric 7,14

 

[Uncle Gizmo]

Column data transposed

Something similar has been covered before, this thread here also links to other threads of a similar nature.

 

[Cosmos75]

Try this - Concatenating unique field values for records matching a query's GROUP BY clause