Combine field data

[TLMM]

I am trying to combine field data from various records to display on an
Access report.

For example,

If I have the field "Community", how can I take all the different values in
the Community field for each record and display them in a text box on a
report instead of listing every record and the corresponding community for
each one?

I would like to display something like this:

CommunityA, CommunityB, CommunityC, CommunityD...

Is it possible to do this? Any help would be greatly appreciated.

Thanks!

 

[Duane Hookom]

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