Concatenated Records and GROUP BY in Access

Question

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'm looking to build a / SQL query in GROUP BY title and combine the desc field so that 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 only with SQL (without VBA / scripts)? FOR XML PATH does not seem to work in Access, but only in SQL Server. I tried VBA here How to improve the efficiency of this request and VBA? but he is too slow.

Or is there a function that can be used that does not execute continuously while the request is already open?

Answer 1

Access does not have Group_Concat: /. There is probably no solution excluding VBA.
Here is one of the possible ones: Concatenating strings through a query