‘List’ aggregate function

[David Cleave]

Hi all

Is there a way to write a query, which, like an aggregate query, combines
multiple records into one, but by listing them in a comma delimited list?

For example, let’s say I have a select query with one field, ‘Name’, which
returns:
Tom
Dick
Harry

I would like to write a query which returns one record:
Tom, Dick, Harry

How would I do this?

Thanks

David

 

[Jeff Boyce]

David

A fellow MVP (Duane H.) offers:

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

Good luck

Jeff Boyce
<Access MVP>