format calculated field

[mabi]

When inserting a calculation into a query, how would you
format the result to a default number (0) if the result
would be an error?

Example:
SELECT

.a,

.b, (

.a)/(

.b) AS c
ORDER BY (

.a)/(

.b) DESC

If a and b both contained 0, the result of (

.a)/
(

.b) would be "#ERROR" ... how can I get the field
to display "0"?

Thanks in advance for the help ....

 

[Allen Browne]

SELECT

.a,

.b,
IIf(

.b = 0 , 0,

.a /

.b) AS c
FROM ...