title: MS Access 2007 - Receiving Syntax Error in query expression
body: <p>MS Access 2007 - Receiving Syntax Error in query expression. Want to delete a record from one table (Parties) using another table's (Export_Extras) field (EmailEfile does not contain Email)</p>
  
  <pre><code>delete from Parties where Document_ID in
  (select Document_ID from export_extras where EmailEfile is not like '%Email%')
  </code></pre>