Calculation Error

  • Thread starter Thread starter Scott Holtzman
  • Start date Start date
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
 
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])
 
Back
Top