In Access, there is no such function named "NullIf".
Code:
SUM(O.MENGE/NULLIF((A.ZZVND_TIER_QTY)*(A.ZZVND_TIE_QTY)),0) AS [Pallet1],
SUM(O.MENGE/NULLIF((E.ZZVND_TIER_QTY)*(E.ZZVND_TIE_QTY)),0) AS [Pallet2]
Maybe you mean "NZ()"???
Code:
SUM(O.MENGE/NZ((A.ZZVND_TIER_QTY)*(A.ZZVND_TIE_QTY)),1) AS [Pallet1],
SUM(O.MENGE/NZ((E.ZZVND_TIER_QTY)*(E.ZZVND_TIE_QTY)),1) AS [Pallet2]
And I would change the zero to a one, so you don't get a divide by zero error.
Even then you could get a zero in the divisor. Maybe:
Code:
SUM(O.MENGE/IIF(NZ((A.ZZVND_TIER_QTY)*(A.ZZVND_TIE_QTY)),1)=0,1,NZ((A.ZZVND_TIER_QTY)*(A.ZZVND_TIE_QTY)),1)) AS [Pallet1],
SUM(O.MENGE/IIF(NZ((E.ZZVND_TIER_QTY)*(E.ZZVND_TIE_QTY)),1)=0,1,NZ((E.ZZVND_TIER_QTY)*(E.ZZVND_TIE_QTY)),1)) AS [Pallet2]