连接Access中的记录和GROUP BY

I have a table like this:title part descBlah This 1 This begins theBlah This 2 example table.Some Record 1 HelloAnother 1 This text extends a bitAnother 2 further so it is inAnother 3 another record in theAnother 4 tableIn Access, I am looking to build a query/SQL to GROUP BY title and concatenate the desc field so it looks like this:title descBlah This This begins the example table.Some Record HelloAnother This text extends a bit further so it is in another record in the tableHow 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? 解决方案 There is no Group_Concat in Access :/. Probably there is no solution that excludes VBA.Here is one possible: Concatenating Rows through a query 这篇关于连接Access中的记录和GROUP BY的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！