title: Access query to include all records even if 1 field has missing data
body: <p>How can I get MS Access 2010 to include data in a query if 1 field has missing data. </p>
  
  <p>IE: I have a <code>sn</code> column in <code>tblPropertydevices</code> and a <code>sn</code> column in <code>tblBrentwoodID</code> that is imported from another source. If there is a typo in the imported data <code>sn</code> column, the entire report is not printed. </p>
  
  <p>I would like for the report to print all reports &amp; ignore the missing data in the one column. I have tried "&lt;>"" Or is null" in the criteria for that column wth no results.</p>
  
  <p>The query pulls data from several tables and prints test reports based on date tested and tech#. That is the only 2 fields that absolutely have to match.</p>