Creating comma seperated lists from multiple records

[Guest]

I currently have a form with a sub form that lists all the team members
involved in a project i.e.:

Joe
Jill
Bob
Jen

The names are all pulled from different records in a “Team Members†table
that are associated with the current Project.

For presentation purposes, I want to present this list as:
Joe, Jill, Bob, Jen

Any help would be much appreciated. Thank you.

 

[Ken Snell [MVP]]

What you seek to do can be done via a VBA function that Duane Hookom, ACCESS
MVP, has written.
http://www.rogersaccesslibrary.com/...Generic+Function+To+Concatenate+Child+Records'

There also is another VBA function to do this at The ACCESS Web:
http://www.mvps.org/access/modules/mdl0004.htm

Either function could be called from your query.