IIF( ISERROR(...

[jmenche]

Hi,

In Excel, I can always trap if a formula generates an error message in an IF statement...=IF(ISERROR(some formula),True,False).

However, I cannot duplicate this in a query expression...=IIF(ISERROR(some formula),True,False) still produces an error message.

Any thoughts?

[Norie]

What error are you trying to trap?

[jmenche]

I have a division formula that generates '#Error'. However, I was also wondering if there were a generic way (like in Excel) to trap ANY error.

[Norie]

Well there actually is an IsError function in Access.

I don't know how it works, I generally try to avoid errors. :)

Is the error due to division by 0?

[jmenche]

Yes. It's a division by zero error.

[Norie]

Well I don't think IsError will catch that error.

At least it didn't in my limited testing