title: How to use a query to populate a table in Access?
body: <p>I am not sure why this is giving me trouble; I have researched it pretty thoroughly but I have not found a good solution.</p>
  
  <p>I have a table called Student that has a column called ClassDescription. I have a query that pulls the right data here:</p>
  
  <pre><code>SELECT Description AS ClassDescription FROM Class AS CL INNER JOIN Student ON CL.StudentId = Student.Id
  </code></pre>
  
  <p>So when I run this, I have the right results. For example, my results might be:</p>
  
  <pre><code>1. ClassDescription1
  2. ClassDescription2
  3. ClassDescription3
  </code></pre>
  
  <p>So in my Student table I would be, if I have 3 entries:</p>
  
  <pre><code>Student1 - ClassDescription1
  Student2 - ClassDescription2
  Student3 - ClassDescription3
  </code></pre>
  
  <p>I have tried using a Lookup but you can't actually make a query in the Expression Builder?</p>
  
  <p>I can't seem to actually populate the ClassDescription column in the Student table. I have the correct query, but I can't link them appropriately.</p>