You can use CASE function to check for nSd=0 and return whatever value you want. For example
CASE WHEN nSd<>0 THEN (a.nResult - nMean) / nSd ELSE NULL END
>
>I have the following query that performs some statistical calculations:
>
<snip>
The problem is with the nSdi calculations. The formula for this field is (a.nResult - nMean) / nSd. When try the execute the query I am getting the Divide by zero error encountered error mesage.
--sb--