Creating comma delimited values...

[mcescher]

Is there a way in an Access query to select the values from one column
and return a line of comma delimited values?

Example:
ID ExText
1 Dog
4 Cat
9 Mouse
15 Parrot
23 Snake

Returns:
Dog, Cat, Mouse, Parrot, Snake

Sorting isn't important, variable number of records, usually 20 or
less. ID's not sequential.

Thanks so much for your consideration,
Chris M.

 

[Marshall Barton]

Is there a way in an Access query to select the values from one column
and return a line of comma delimited values?

Example:
ID ExText
1 Dog
4 Cat
9 Mouse
15 Parrot
23 Snake

Returns:
Dog, Cat, Mouse, Parrot, Snake

Sorting isn't important, variable number of records, usually 20 or
less. ID's not sequential.

You need a custom function to do that. There's a good one
here:
http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'

 

[Van T. Dinh]

See also The Access Web article:

http://www.mvps.org/access/modules/mdl0008.htm