Division by 0

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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."
 
Back
Top