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

C

cleoozo

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
 
A

Allen Browne

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])
 
Top