Concatenation in MS Access SQL View
Posted on 2013-10-29
I just modified a report in MS Access (2010) originally developed by another (already gone) person.
I inserted a new field to the already existing report, containing various tables. All very simple and it woks perfectly fine. However, when I wanted to concatenate the results of that field into one row I just Couldn't!!! I tried several functions and even tried the listagg function that works for Oracle 11.2g (which we have), but no luck.
Since the report is based on Access' SQL View and not in VBA, I had to go to that view to manually try to insert a concatenating function, but none of them seem to be supported.
When I run the query this is what I get:
John Doe SKS
John Doe LHN
John Doe JM
What I would like to see, as you probably now, is:
John Doe SKS, LHN, JM
Is there a way to do it in Access by using the SQL view at all? Is there another way?
Please help!!! I am stuck here.