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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access form continuous 1
access form 1
How to Create an S-Curve from Custom Field? 0
Autonumber field in Excel that behaves the same as Access 0
Shift several columns in table 4
Turn Off Access Field Re-name? Calculation fields in query 1
Strange results from Access Union Query 2
Exclude Multiple Zeros in Query 4

Top