title: Concatenating field data into string via Access SQL
body: <p>Imagine the following table</p>
  
  <pre><code>ID | Name
  ----------
  1  | Shaun
  1  | Terrence
  2  | Jessica
  </code></pre>
  
  <p>I need to concatenate the string data in Name based on ID</p>
  
  <pre><code>ID | Name
  -----------
  1  | Shaun, Terrence
  2  | Jessica
  </code></pre>
  
  <p>I am using an access database. I was thinking I could do a pivot transform and try to concatenate those fields but the problem is its hard to dynamically loop through the total field count. Any ideas?</p>
  
  <p>**Edit: Order does not matter, I just want to concatenate based on ID with , and space being the delimiter. I am calling this sql code using an ADO connection from excel vba.</p>