Query That Groups Records in a Field (1 Viewer)

[bmcgree1]

Hello All,
I have 2 fields, one is a Foreign Key field and the other a Name field. My query shows only one foreign key value at a time (i.e. all = 25) but I have have 3 or 4 Name records with this key. I want my query to take all the names I have in my Name field and group them together, seperated by commas.

So instead of this:
Foreign Key Name
25 John Doe
25 Jane Doe
25 Adam Doe

It will show this:
Foreign Key Name
25 John Doe, Jane Doe, Adam Doe

Any help is GREATLY appreciated. Thank you,

Brendan

 

[boblarson]

This should help.

 

[bmcgree1]

Was really confused at first, until I saw the code below. This is perfect! Thank you much!