Combine text from same text field

[Martin T]

I'd like to write some sort of aggregate select query that combines the text
in a particular field from multiple records where the value in another field
is the same for those records.

For example:

I have a table with two fields, SomeID and Name (assume there is no primary
key). There are records where SomeID is the same and I'd like to be able to
select a dataset that had a single row for each SomeID and combine all the
values in the Name field into a single field in each selected record.

Anyone know how I can do this? If you can provide the SQL with any embedded
expressions it'd be most apprceiated.

Thanks.

 

[Ken Snell [MVP]]

What you seek to do can be done via a VBA function that Duane Hookom, ACCESS
MVP, has written.
http://www.rogersaccesslibrary.com/...Generic+Function+To+Concatenate+Child+Records'

There also is another VBA function to do this at The ACCESS Web:
http://www.mvps.org/access/modules/mdl0004.htm

Either function could be called from your query.

 

[Martin T]

Ken,

That first link doesn't seem to work anymore. Any idea if the page is still
available elsewhere?

 

[Martin T]

Found it:

http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'

Thanks.

 

[Ken Snell [MVP]]

Works for me.....

but this may be needed for some browsers:
http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'