How to replace #Error with NA in an Access Report?

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

Guest

I have a report that has three fields. One field is number applicable, one is
number due and the third in percent compliant. I have the percent compliant
populate by dividing the number due by the number applicable. Everything
works fine unless there are none applicable, then I get the #Error in the
percent applicable field. I need to know how to code this to read NA.

Thanks
 
Division by zero results in an error.

To avoid that, use something like this in the Control Source of your text
box:
=IIf([number applicable]=0, "N/A", [number due] / [number applicable])
 
Back
Top