Division by 0

[Guest]

I am making a report and some time there is a condition when we get "#div0"
Or "#Error" , I need to use sum function but when I get "#div0" Or "#Error"
in sum range report don't open.

Please advise if there is any solution to use Sum with "#Error" Or div0 ??
Thanks

 

[Allen Browne]

Use IIf() to avoid the case.

For example, if you have 2 fields named Num and Denom:
=IIf([Denom]=0, Null, [Num] / [Denom])

Come to think of it, that is probably how database software like Access
should work anyway, since Null covers the meaning "undefined."