Share via

How do list results of a column in a table in one field separated by commas in MS Access

imodett 41 Reputation points
2024-10-16T18:48:02.2+00:00

I would like to know how to get a column into a query field. Similar to how in Access if you use the multi-value field in MS Access. However, i do not wish to use the mutli-value.

For example, if I had a table

column1 with
A
C
D
F
G

(one letter in each row under Colmn1).

and I wanted to display it in a query field like: A, C, D, F, G

How could i achieve this?

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
395 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
879 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Karl Donaubauer 1,816 Reputation points MVP
    2024-10-16T20:24:14.0433333+00:00

    Hi,

    Allen Browne has a ready made function to do it:

    http://www.allenbrowne.com/func-concat.html

    Servus
    Karl

    Access Forever, News, DevCon
    Access-Entwickler-Konferenz AEK - 19./20.10. Nürnberg

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.