我有一个这样的表：

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

在Access中，我希望为GROUP BY建立一个查询/ SQLtitle并连接该desc字段，因此它看起来像这样：

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

仅使用SQL（没有VBA /脚本）怎么能做到？FOR XML PATH似乎在Access中不起作用，仅在SQLServer中起作用。

还是有一个可以使用的功能在查询已经打开时不能连续运行？