Retrieve Multiple Values into a comma-delimited string

[W Dean]

Hi,

I need to retrieve the contents of a particular field (Region) into a comma
delimited string , for example, if I had

Town Region
a 1
a 2
a 3


it could return

a
1,2,3

Does anyone know how to do this using access sql.

The sql statement will be called using ado

Wodge

 

[Duane Hookom]

There is a generic concatenate function that can be used. Find the function
and demo at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

 

[W Dean]

Hi,

Is there a way to do it just using sql?

I'm calling the query from an asp page using ADO and I don't thing user
defined functions will work.

w dean

 

[Duane Hookom]

There is a method but it requires a table with unique towns (primary key)
and a larger text field (Regions) to update with the region values. If I
recall correctly join these two tables in a query and make it into an update
query. Update the Regions field to:
Update To: [Regions] & " " & [Region]