How to combine mulitple rows into single row in access using sql query

[Joyce]

Iam new to microsoft access.



I need to combine multiple rows into single row in access using sql query

Could anyone help me how to write the query?


Field 1 Field 2

A01 123
A02 234
A03 345

Result should be A01 123,234,345





Thanks in advance,

[pbaldy]

Most solution use a function like this:

http://allenbrowne.com/func-concat.html