title: Update using Sum -Error
body: <p>Keep on getting error</p>
  
  <blockquote>
    <p>you tried to execute a query that does not include the specified expression</p>
  </blockquote>
  
  <p>My SQL looks as follows:</p>
  
  <pre><code>UPDATE TblField LEFT JOIN TblTempStats ON TblField.DomainCatID = TblTempStats.DomainCatID 
  SET TblTempStats.EmptyFields = Sum(IIf([fieldname] Is Null,1,0));
  </code></pre>
  
  <p>Any ideas as to why? </p>