Microsoft Access - Verticle List to 1 comma separated field


L

laurco

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

Group_id Email
1 (e-mail address removed)
1 (e-mail address removed)
1 (e-mail address removed)
2 (e-mail address removed)
3 (e-mail address removed)
3 (e-mail address removed)

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

Group_id Emails
1 (e-mail address removed), (e-mail address removed), (e-mail address removed)
2 (e-mail address removed)
3 (e-mail address removed), (e-mail address removed)

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

Thanks in advance!
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top