title: Microsoft Access condense multiple lines in a table
body: <p>I have a question in MS Access 2007 and I hope someone has the answer. I have a long but simple table containing customer names and the days of the week that deliveries are made. I would like to summarize this table by listing the name and all the days into one new field "ALLDays" while still preserving all the data.</p>
  
  <p>The source table looks something like this:</p>
  
  <pre><code>Name         Day  
  CustomerA    Monday  
  CustomerA    Thursday  
  CustomerB    Tuesday  
  CustomerB    Friday  
  CustomerC    Wednesday  
  CustomerC    Saturday  
  </code></pre>
  
  <p>I would like to have a query which returns results like this:</p>
  
  <pre><code>Name         ALLDays  
  CustomerA    Monday, Thursday  
  CustomerB    Tuesday, Friday  
  CustomerC    Wednesday, Saturday  
  </code></pre>
  
  <p>Thanks.</p>