Access Query+division by 0 error

[Guest]

In Access, in a query, I want it to return a "0" if the calculation returns a
"DIV/0!" error. In Excel, my formula would be:
=IF(ISERROR(rate:[sold]/10),0,rate:[sold]/10). How do I do this in Access?

 

[Marshall Barton]

In Access, in a query, I want it to return a "0" if the calculation returns a
"DIV/0!" error. In Excel, my formula would be:
=IF(ISERROR(rate:[sold]/10),0,rate:[sold]/10). How do I do this in Access?

DOn't see how that expression can generate that error, but
the equivalent expression in Access would be (assuming that
Rate is a table in the query's From clause):

IIf(IsError([sold]/10),0,[sold]/10)