title: MS-Access query to collect comma-separated results in another column
body: <p>If I have a table called <strong>Activities</strong>:</p>
  
  <p><img src="https://i.stack.imgur.com/dlc0S.jpg" alt="ActivitiesTable"></p>
  
  <p>..and another table called <strong>Tutors</strong>:</p>
  
  <p><img src="https://i.stack.imgur.com/zrqtf.jpg" alt="TutorsTable"></p>
  
  <p>If I were to do a simple <code>LEFT JOIN</code> for the tutor names on their LearnerId / InstanceId records in the activities table I would get a result like this:</p>
  
  <p><img src="https://i.stack.imgur.com/m9PYt.jpg" alt="QueryResult"></p>
  
  <p>(Sql for the above result):</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT Activities.LearnerId, Activities.InstanceId, 
  Activities.LastName, Activities.FirstName, Activities.Activity, 
  Tutors.TutorLastName, Tutors.TutorFirstName
  FROM Activities 
  LEFT JOIN Tutors ON (Activities.InstanceId = Tutors.InstanceId) 
  AND (Activities.LearnerId = Tutors.LearnerId);
  </code></pre>
  
  <p>I would prefer that the number of records in the <strong>Activities</strong> table is maintained (i.e. the query results in 4 records rather 7). </p>
  
  <p>I would also like every tutor matched to a LearnerId / InstanceId record to be collected in another column called <strong>Tutors(s)</strong>, where the names of the related tutors are all listed in one field with commas separating each tutor. In other words, a results that looks like this:</p>
  
  <p><img src="https://i.stack.imgur.com/gnTOe.jpg" alt="PrefQueryResult"></p>
  
  <p>...is it possible to do this just in SQL, or can this only be achieved in VBA?</p>