Report to aggregate all the people's names of the field [NAMES] recordset.

[Joe M]

Hi, if in a table I have a name field populated with people's names for the
recordset. How do I create a report to aggregate all the people's names from
this recordset into a single line, with a comma between each names. Thanks.

 

[Guest]

Hi Joe,

You have to do that by building a string using VB code in the report.
There's no way to do it in a query.

Do you need help with the VB code?

 

[Marshall Barton]

Hi, if in a table I have a name field populated with people's names for the
recordset. How do I create a report to aggregate all the people's names from
this recordset into a single line, with a comma between each names. Thanks.

You'll need to create a function to do that. Here's a
popular one:

http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'

You could google for several others if you prefer.

 

[John Vinson]

Hi, if in a table I have a name field populated with people's names for the
recordset. How do I create a report to aggregate all the people's names from
this recordset into a single line, with a comma between each names. Thanks.

There's some sample VBA code to do this at

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


John W. Vinson[MVP]

 

[Joe M]

Hi Ed,
Yes I need help with VB code, what's a simple one to use for a
simple need as this??? To aggregate all names in the recordset, and separate
by a comma. The field [NAME]
Thanks.

 

[Peter Franklin]

Hi Joe,

You have to do that by building a string using VB code in the report.
There's no way to do it in a query.

This isn't true, Ed . Dev Ashish's function suggested by John Vinson
in the original thread can be included in a query (my thanks to John
for pointing me in that direction some time ago . It might slow it
down though, if there are many records.

Do you need help with the VB code?

HTH
Peter Franklin