Access #Error in calculated field

J

JPS

I have an access query that returns #Error on fields where I am dividing a
number by zero.

My formula in the query grid is -----> Average:[Field1]/[Field2]

How can I prevent this?
 
Top