SQL MS Access - Misuse of Null

Question

Now I got rid of the overflow of this request, giving a long one, but now I get

Error 94: Invalid use of NULL

Can someone tell me what could be the problem?

SQL query:

Sum(CLng(
  [TotaalPrijs]/([tbl_ArtikelsPerOrder]![Aantal]*[Totaal])*
  [tbl_ArtikelVerwijderdUitZaaglijst]![Aantal]
)) AS GezaagdeOmzet

Answer 1

One or more column values NULL, and this cannot be converted to an integer, therefore causing this error. Try wrapping a value in a function Nz, for example.Nz([My_value],0)

This will make it return 0if found NULL.

Answer 2

NULL. NULL, Integer, , .

SQL Query:

Sum(CLng(
   Nz(
      [TotaalPrijs]/([tbl_ArtikelsPerOrder]![Aantal]*[Totaal])*
         [tbl_ArtikelVerwijderdUitZaaglijst]![Aantal],
      0
   )
)) AS GezaagdeOmzet

Answer 3

It is impossible to say for sure without additional information, but TotaalPrijsor AantalNULL in your data?