Equivalent formula for IFERROR

[ahmahfood]

I'm working on streamlining a report that pulls data via Access, then uses formulas in Excel including IFERROR. I'm currently using a macro to run about a dozen queries in sequence, but would like to add a query that automatically runs my IFERROR formula rather than making a new one in Excel every time.

Is there an equivalent formula to use in Access? My Excel formula currently looks like:

=IF(H2="BX",W2,IF(IFERROR(W2/I2,0)<0,0,IFERROR(W2/I2,0)))

Thanks in advance if anyone is able to help with this!

 

[plog]

No. You have to validate your data to make sure no errors will be encountered before you do the calculation (check for nulls, make sure not dividing by 0, not performing math on strings, etc). Here's another thread on this forum about it: http://www.access-programmers.co.uk/forums/showthread.php?t=217455