Retrieve Multiple Values into a comma-delimited string

  • Thread starter Thread starter W Dean
  • Start date Start date
W

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
 
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
 
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]
 
Back
Top