Replacing #Num! error with a zero

[gmccray]

SELECT OperatorID, Sum(AppsChecked) AS TotAppsChecked, Sum((AppsChecked)-(AppErrors)) AS TotAppsCorrect, Format((TotAppsCorrect)/(TotAppsChecked), "Percent") AS PctCorrect, Sum(AppErrors) AS TotAppErrors, Format((TotAppErrors)/(TotAppsChecked), "Percent") AS PctErrors
FROM Stats
WHERE (((Stats.OperatorId)=[Enter OperatorID]) AND ((Stats.Date) Between [Enter Start Date] And [Enter End Date]))
GROUP BY OperatorId;


Hello All,
I am trying to replace a #Num! error with a zero (0). It is the product of division by zero when trying calculate a percentage. The code I am using is above. Can you help?

[pbaldy]

In general:

IIf(B = 0, 0, A/B)

[gmccray]

I'm afraid I am not that advanced yet, can you give me a more descriptive example using the code I supplied? I really appreciate your kind assistance!

[gmccray]

Tried it, got it! Thanks!

[pbaldy]

Happy to help! Thought you might get it if you tried.