title: SQL MS Access - Invalid Use of Null
body: <p>I have now got rid of the overflow on this query by forcing to a long but now I get </p>
  
  <p><strong>Error 94: Invalid Use of NULL</strong> </p>
  
  <p>Can anyone tell me what the problem could be?</p>
  
  <p>SQL Query:</p>
  
  <pre><code>Sum(CLng(
    [TotaalPrijs]/([tbl_ArtikelsPerOrder]![Aantal]*[Totaal])*
    [tbl_ArtikelVerwijderdUitZaaglijst]![Aantal]
  )) AS GezaagdeOmzet
  </code></pre>