Concatenate records and GROUP BY in Access
concatenation, ms-access, sql
Solution
There is no Group_Concat in Access :/. Probably there is no solution that excludes VBA. Here is one possible: Concatenating Rows through a query
Problem
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?