Access #Error in calculated field

  • Thread starter Thread starter JPS
  • Start date Start date
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?
 
Back
Top