title: Data exclusions based on two-tables MS Access
body: <p>I have table A which includes all data based on a read date. For example:</p>
  
  <pre><code>Read Date----Data
  1/1/2016-----3
  1/2/2016-----10
  1/3/2016-----42
  1/4/2016-----16
  12/25/2016----32
  12/26/2016----12
  12/27/2016-----8
  </code></pre>
  
  <p>From that data set, I created a query that looks at a list of off-peak holidays, as well as off peak days, and created a table from that. This table looks like:</p>
  
  <pre><code>Read Date ----- Data
  1/1/2016---------3
  1/2/2016---------10 
  12/25/2016-------32
  </code></pre>
  
  <p>I need to create a query that will give me table A data EXCLUDING table B data. Which would look something like this:</p>
  
  <pre><code>Read Date ----- Data
  1/3/2016---------42
  1/4/2016---------16
  12/26/2016-------12
  12/27/2016--------8
  </code></pre>
  
  <p>I have tried different join, NOT IN, WHERE NOT, and many others, which would sadly just return all results from Table A or no results at all.</p>
  
  <p>PS - I apologize for the formatting, new to all of this.</p>
  
  <p>NOT IN, WHERE NOT, &lt;>, LEFT JOIN, ISNULL</p>