Multiple columns from one set of data?

[HappyBlue]

I have a table of data listing interests of individuals that is a list as
below;

Person1: Interest1
Person1: Interest2
Person1: Interest3
Person2: Interest1
Person2: Interest2
Person3: Interest1 and so on

The interests are free test fields so there are literally hundreds of
different interests. I have been asked to create an export showing the
interests of each person ..

Person1: Interest1: Interest2: Interest3
Person2: Interest1: Interest2
Person3: Interest1: Interest2: Interest3 and so on

I have looked at using a CrossTab for this, but that doesn't give the
results I need. Is this possible and if so, how do I do it??

Thanks in advance for any help,
Blue

 

[John Spencer]

Quoting Duane Hookom

I use a generic Concatenate() function.
....

See:
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[HappyBlue]

Thats exactly what I wanted, thanks for pointing it out! Duane does it again