title: How to display mulitple records in a single row as comma separated
body: <p>I'm newbie to MS Access.</p>
  
  <p>How to display multiple records in a single row as comma separated in MS Access?</p>
  
  <p>For example I have a table</p>
  
  <pre><code>state
  AL
  AK
  MA
  HI
  TX
  VI
  GU
  </code></pre>
  
  <p>I want to retrive data as like below</p>
  
  <pre><code>State
  AL, AK, MA, HI, TX, VI, GU
  </code></pre>
  
  <p>Can anyone help me with a query to do this?</p>