I have a table like this:
title part desc Blah This 1 This begins the Blah This 2 example table. Some Record 1 Hello Another 1 This text extends a bit Another 2 further so it is in Another 3 another record in the Another 4 table
In Access, I am looking to build a query/SQL to GROUP BY title
and concatenate the desc
field so it looks like this:
title desc Blah This This begins the example table. Some Record Hello Another This text extends a bit further so it is in another record in the table
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