title: Concatenate records and GROUP BY in Access
body: <p>I have a table like this:</p>
  
  <pre><code>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
  </code></pre>
  
  <p>In Access, I am looking to build a query/SQL to GROUP BY <code>title</code> and concatenate the <code>desc</code> field so it looks like this:</p>
  
  <pre><code>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
  </code></pre>
  
  <p>How can this be done with just SQL (no VBA/scripts)? <code>FOR XML PATH</code> does not seem to work in Access, only SQL Server. I've tried VBA here <a href="https://stackoverflow.com/questions/15550671/how-to-improve-efficiency-of-this-query-vba">How to improve efficiency of this query &amp; VBA?</a>, but it is simply too slow.</p>
  
  <p>Or is there a function that can be used that is not continually run while the query is already open?</p>