title: A query to combine multiple row values into one field in MS-Access 2003?
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/92698/combine-rows-in-access-2007">Combine rows in Access 2007</a>  </p>
  </blockquote>
  
  
  
  <p>If I have two tables: let's say OrderStatus and Comments, how can I sum up all comments which are made related to one order, so that I can put them into one field?</p>
  
  <p>Tabel OrderStatus:</p>
  
  <pre><code>OrderID      OrderStatus       OrderDate
  64           OK                13.08.2011
  77           Deleted           21.06.2011
  99           OK                18.04.2011
  </code></pre>
  
  <p>Table Comments:</p>
  
  <pre><code>CommID       CommOrder         CommText
  1            64                "EAN 304"
  2            64                "resent"
  3            64                "no. 499"
  4            99                "in stock"
  5            99                "EAN 111"
  </code></pre>
  
  <p>What I want:</p>
  
  <pre><code>OrderID    OrderStatus         Comments
  64         OK                  "EAN 304, resent, no. 499"
  99         OK                  "in stock, EAN 111"
  </code></pre>
  
  <p>The total number of comments related to an order status is unknown.</p>
  
  <p>I am trying to achieve this with Access SQL-subqueries. I already managed with own VBA routines called from the query builder but the OrderStatus table has more than 30,000 records and VBA is too slow (takes more than 10 minutes to generate a report). In Microsoft Access, SQL is much faster than VBA but can be complicated.
  From Access 2007 on, Microsoft has included <a href="http://office.microsoft.com/en-us/access-help/guide-to-multivalued-fields-HA001233722.aspx" rel="nofollow noreferrer">multivalued fields</a>, however I'm using Access 2003 which isn't capable of automatically listing multiple values comma-separated.</p>
  
  <p>Thanks for your help!</p>