Access Query+division by 0 error

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Gimpy815 said:
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?
Click to expand...


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)
 
Back
Top