Nz doesn’t work (A2KSR1)

Topic

New Reply

I have a qery that performs a sum on two controls and provides a percentage through an expression. Of course if either or both of the two controls have a null field I get an error so I wrote the following:
Percent:Nz([control1],0)/Nz([control2],0)
but it doesn’t work. It still shows error when both fields are null. How can I have 0/0 or null/null to show zero?

Reply | Quote

Replies

If both fields are null, your use of the Nz function will cause a divide by zero error. You’re going to have to use an IIf() like this:

Percent: IIf(IsNull([control2]),0,nz([control1])/[control2])

Reply | Quote