#Error should show zero

[accessaspire219]

I have query where any number that is zero shows up as #error; I need it to show zero. I wanted to know if there was a way to do it other than using an IIf statement.
Thanks.

 

[gemma-the-husky]

why would zero show up as error

do you mean you are using a blank/null in a calculation (RATHER THAN A ZERO)

if so wrapping the potential blank with nz(potentialblank,0) will change it to a zero.