Combine field values from multiple records as a list in a report?

[Guest]

Is there a way to combine multiple field values from all matching records
into one control in a report with a comma separating each value?

I am trying to set up a report that lists all of the laborers that will be
working on a particular job; however, instead of listing the names in a
vertical column I want them to look like this: "Achmed, Bob, Hans, etc" Any
ideas?

Thanks!

 

[Allen Browne]

You will need to be comfortable with VBA code to achieve that.

Details:
Return a concatenated list of sub-record values
at:
http://www.mvps.org/access/modules/mdl0004.htm

 

[fredg]

Is there a way to combine multiple field values from all matching records
into one control in a report with a comma separating each value?

I am trying to set up a report that lists all of the laborers that will be
working on a particular job; however, instead of listing the names in a
vertical column I want them to look like this: "Achmed, Bob, Hans, etc" Any
ideas?

Thanks!

List them where? In the Report Footer?

Add an unbound text control to the Report footer.
Set it's Can Grow property to Yes.
Name this control NameSummary

Code the Detail Format event:
Me![NameSummary] = Me![NameSummary] & (", " + Trim([LaborerName]))