title: MS Access 2003 - Concatenating Field Types of Same ID on a Form
body: <p>Ok so a guy at work has a little access database he uses to keep track of things. He has this form that he uses that already queries what he needs and produces the results on a form and that is really all he needs.</p>
  
  <p>One thing is that he has duplicates for every record that comes up with a different "Type" as a field "indentifier" (what I call it)...here is an example:</p>
  
  <pre><code>ID     Name          Price     Type
  1      Prodcut A     $10       A1
  1      Product A     $10       A2
  1      Product A     $10       A3
  2      Product B     $12       A1
  etc
  </code></pre>
  
  <p>naturally this is supposed to occur and he wants to see all the types but given it ends up being a mile long, he asked me if there was a way to concatenate the "types" so the following would be displayed:</p>
  
  <pre><code>ID     Name          Price     Type
  1      Prodcut A     $10       A1, A2, A3
  1      Product B     $12       A1, A2, A3
  1      Product C     $14       A1, A2, A3
  2      Product D     $7        A1, A2, A3
  </code></pre>
  
  <p>...on the form. Can anyone please help me with this? Thanks!</p>