MS Access - Check for #Error in calculation

I'm doing some math  ##/##
I don't want #Error in the results of the qry
If the ressult is #Error I want the the result to be set to NULL

How would I do this within a select
Who is Participating?
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
I'm assuming this is a divide-by-zero error? You didn't mention exactly what error you think it may be, so I'm assuming the standard.

You can use IIF:

YourCalculatedField: IIF(SomeField=0, Null, OtherField/SomeField)
keschusterAuthor Commented:
I resolved this by making the join a bit smarter by checking for null on the join instead of letting access tell me it was an error.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.