records listed in one field

[Guest]

Hello. I have a report to construct in which one of the fields is to display
all the services our company provides to the client. A continuous form is
used to input the services into a table. So on the table each service is one
record. I would need to show all the services on the table (for the client)
in one field on the report. Is this possible to do? If so, how? Is there
an example to view? Originally (and still today), the VP wants to be able to
also sort by using the different services. Which is why the table is set up
as is.
Any assistance is appreciated.
*** John

 

[Steve Schapel]

John,

There is code to do this at
http://www.mvps.org/access/modules/mdl0004.htm

Duane Hookom has also made available a function which works well. I
can't put my fingers on an unadulterated version right now, but a
Google search on 'concatenate Hookom' will probably unearth it pretty
promptly.