title: Collapse MS Access Table
body: <p>I have a table similar to the Example Source Table shown below that I would like to collapse based on the ID field (see Example Collapsed Table).  I can do this with code but it inflates my Access database beyound the 2 GB maximum size so I'm hoping there is a way to do it with a query.  I should probably note that for any given ID value I don't need to worry about more than one record having a value in field One, Two, Three, or Four. </p>
  
  <p>Example Source Table:</p>
  
  <pre><code>ID  One Two  Three  Four
  1   My       Is
  1                   Matt
  1       Name
  2   My       Is     Matt
  2       Name
  3   My  Name Is     Matt
  </code></pre>
  
  <p>Example Collapsed Table:</p>
  
  <pre><code>ID  One Two   Three  Four
  1   My  Name    Is   Matt
  2   My  Name    Is   Matt
  3   My  Name    Is   Matt
  </code></pre>
  
  <p>Thanks in advance for any help or guidence provided.</p>
  
  <p>Matt</p>