Report Output

[Guest]

I have a report based on a query that works fine I just want to know how to
format the output in a different manner.
I now have the following:

Person one people 1
people 2
people 3

I would like to format the report to produce the output in the following
manner:

Person one people1 ; people 2 ; people 3

How do I write a procedure or use a function to get my output all on one
line as in my example?

 

[Duane Hookom]

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