Cross tab query and concatenating multiple fields into one field

Question

Access 2007:

I am trying to take the following access table:

Full_Name        Email_Name       Email_Address              Domain           Group

Donna Jean      djean                     ******@email.com        adom               user

Donna Jean      djean                     ******@email.com        adom               world

Diane Ann        dann                       ******@email.com         ddom               employee

Diane Ann        dann                       ******@email.com         ddom               contractor

and query it to combine the rows with the same first four fields of information into one line with the group information merged into one field comma delimited:

Full_Name        Email_Name       Email_Address              Domain           Group

Donna Jean      djean                     ******@email.com        adom               user, world

Diane Ann         dann                      ******@email.com         ddom               employee, contractor

I have no idea how to do this. Could anyone please help me?

Thank you,

DebraAnn

Answer 1

As far as I know, you will need to use some VBA to do this.

Here are links (url) to three examples on concatenating a field from multiple records into one field in one record.

Duane Hookom

http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=16

Allen Browne

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

The Access Web

http://www.mvps.org/access/modules/mdl0004.htm