catch error from a query

  • Thread starter Thread starter thread
  • Start date Start date
T

thread

hi all,
i build a query that have at least 20 columns
1 of the columns is base on another column that sometimes geting
errors,
when i'm doing "iserror" the problems is not catched.
what should be done in order to flag the error
this is the example:
x: iif(iserror([a]),0,1)
 
Thread,

I think it would be better to try and identify why the error is
occuring, and fix it. What is the nature of the column where you get
the error? Can you give any specific examples?
 

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

iserror function in a query 2
#Error 5
Access Query problem 1
Is it possible to get Access to ignore not recognizing a field nameusing some sort of error handling 1
Vlookup to Access Dlookup 0
Catch error 4
Expression Builder query with zero amounts 5
#Error in Query 2

Back
Top