Dividing by 0 and #Error 1

[dbero]

Hello:

I have a query that contains an x divided by y formula. Often times, the numerator is 0, thus the result is #Error. 0/8 = #Error, which displays on the report.

[CountOfErrors]/SumOfCountInBatch AS ErrorRatio,

Is there a way to intercede and display on the report a more meaningful value, like "Perfect"?


thank you,

 

[jebry]

Hi!

IIf(YourNumber = 0, "Perfect", Format(OtherNumber/YourNumber, "0.00")) As YourField

Of course you can use other formats such as "Percent" if that is appropriate.

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[dbero]

Thank you very much!!