title: Concatenate multiple rows in one field in Access?
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/5517233/ms-access-query-concatenating-rows-through-a-query">Ms Access Query: Concatenating Rows through a query</a>  </p>
  </blockquote>
  
  
  
  <p>I have a table that has many columns, but two of interest: Order Number and Product Type. Currently the table has multiple Product Types per Order. If the customer ordered phone service, TV service and Internet service, then there would be three records - one for each service but all having the same order number. I want to create a reference table to store a concatenated string with all of the services the customer ordered. This way I can summarize my data using this more logical method. I'm using a standard Access 2010 database.</p>
  
  <pre><code>**Current table:**
  
  Order Number | Product Types
  
  100001 | TV
  
  100001 | Phone
  
  100001 | Internet
  
  100002 | Phone
  
  100003 | TV
  
  100003 | Internet
  </code></pre>
  
  <p><strong>Desired reference table</strong></p>
  
  <pre><code>100001 | TV/Phone/Internet
  
  100002 | Phone
  
  100003 | TV/Internet
  </code></pre>