multiple records into one cell

[Lbrister]

I am creating a database in 2003 and am trying to see if there is some way to
combine records like there is for fields for when I am exporting the report
to excel. Currently it puts each name record in its own cell and it would be
much easier on me for them to be in one cell.

 

[Duane Hookom]

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

 

[Lbrister]

This is exactly what I need but the Concatenate function is undefined in my
version of Access 2003. Is this something I am doing wrong or is this
something that has been removed from later versions of access?

 

[John Spencer]

Did you go to the site, download the example, and then copy the Function
from the Sample database into your database?

The concatenate is a custom function written in VBA and is in a module
in the sample database.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================