Skip to content
Advertisement

Concatenate records and GROUP BY in Access

I have a table like this:

In Access, I am looking to build a query/SQL to GROUP BY title and concatenate the desc field so it looks like this:

How can this be done with just SQL (no VBA/scripts)? FOR XML PATH does not seem to work in Access, only SQL Server. I’ve tried VBA here How to improve efficiency of this query & VBA?, but it is simply too slow.

Or is there a function that can be used that is not continually run while the query is already open?

Advertisement

Answer

There is no Group_Concat in Access :/. Probably there is no solution that excludes VBA.
Here is one possible: Concatenating Rows through a query

User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement