title: "Find Unmatched" Query -- Using Queries instead of Tables
body: <p>I'm using Access 2010.</p>
  
  <p>I have a database with multiple tables, each containing different components of teaching data.</p>
  
  <p>Ultimately, I'd like to find "people who will be teaching a course in the upcoming semester and who have never taught before."</p>
  
  <p>Currently, I am doing this through a series of steps:</p>
  
  <ol>
  <li>Creating one table (through a query) that has a list of everyone who is teaching in the upcoming semester and what they are teaching (this data comes from multiple tables). <strong>(tbl_NewInstructors)</strong></li>
  <li>Creating another table (through a query) that has a list of everyone who has ever taught (but not including this upcoming semester). <strong>(tbl_NewInstructors2)</strong></li>
  <li><p>Running this select statement:</p>
  
  <pre><code>SELECT tbl_NewInstructors.Name, tbl_NewInstructors.Course 
  
  FROM tbl_NewInstructors
  
  WHERE (((Exists (SELECT * from tbl_NewInstructors2 
  
  WHERE tbl_NewInstructors2.Name = tbl_NewInstructors.Name))=False));
  </code></pre></li>
  <li><p>Getting my list!</p></li>
  </ol>
  
  <p>The main issue is that I have to create two tables each time I want to run this, and I would RATHER just run a query of my two current select queries, than a query on tables that I create through those queries. Unfortunately, when I try to run a query on the queries, it doesn't work. </p>
  
  <p>Any suggestions?</p>