Format of the Report

[Wendy Simes]

I have a report that shows a product and below each product lists the
clients for this product. I would like to be able to have the client
names on the one line rather than in list form. How do I achieve
this?.

 

[Allen Browne]

You can programmatically concatenate the values together into one string.
Details:
http://www.mvps.org/access/modules/mdl0004.htm

 

[Duane Hookom]

There is also a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.