title: Ms Access Query: Concatenating Rows through a query
body: <p>Suppose I have table in Ms Access with following information:</p>
  
  <pre><code>ColumnA ColumnB
  1       abc
  1       pqr
  1       xyz
  2       efg
  2       hij
  3       asd
  </code></pre>
  
  <p>My question is, how can I concatenate the values in the second column to a row value based on the first column. The query results that I want is as follows:</p>
  
  <pre><code>ColumnA ColumnB
  1       abc, pqr, xyz
  2       efg, hij
  3       asd
  </code></pre>
  
  <p>I want to achieve this through a query. Can someone help me attain this?</p>