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])
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with NA response 1
Formating the output of report's TextBox 6
dlookup based on two criteria 1
How calculate percent difference between fields in same group in a 8
did my question post about Percent in an ACCESS report? 1
Help on getting a result in a report 4
how to get a text/letters to equal to a percentage 5
Calculate between SubReport and Report 1

Back
Top