Calculation Error

S

Scott Holtzman

In a query I am trying to return a percent value. However, when there is no
divisor the query shows an error. I would like to create an IFF statement
saying that if the function produces an error return zero, else return the
percentage. I was looking for a ISERROR function or something along that
lines, but I could not find it... Any ideas on how to get around this
issue...

Thanks,

Scott Holtzman
 
R

Rick Brandt

Scott Holtzman said:
In a query I am trying to return a percent value. However, when there is no
divisor the query shows an error. I would like to create an IFF statement
saying that if the function produces an error return zero, else return the
percentage. I was looking for a ISERROR function or something along that
lines, but I could not find it... Any ideas on how to get around this
issue...
Click to expand...

=IIf([DivisorField]=0,0,[SomeField]/[DivisorField])
 

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

IIF statement 1
A useful AVERAGE calculation without using the built-in AVERAGE function 3
calculating a percentage 1
IsError function 1
Custom Function behaving strangely in query 1
Options for DIV#/0 6
How to use IsError()? 1
Overflow error on calculate field in query - Help Please 1

Top