Microsoft Access - Verticle List to 1 comma separated field

[laurco]

Hi All,
I have a table set up as follows:

Group_id Email
1 [email protected]
1 [email protected]
1 [email protected]
2 [email protected]
3 [email protected]
3 [email protected]

And I'd like to have a query that would show the data as follows:

Group_id Emails
1 [email protected], [email protected], [email protected]
2 [email protected]
3 [email protected], [email protected]

Could anyone else me with some basic code to accomplish this?

Thanks in advance!