M
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.
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.