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?
 
TheAverage: IIf(IsNull([Field2])= True, Null, [Field1]/[Field2])
 
You must log in or register to reply here.

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

Turn Off Access Field Re-name? Calculation fields in query 2
DSum update query with multiple fields 0
Using If or Iif to determine a value 3
NZ function 1
Shift several columns in table 4
Make-table query with around 2 ml records taking too long 0
Strange results from Access Union Query 3
Calculated field, sum/avg results of qry? 3

Back
Top