Access- Iferror functionality

[sanket_sk]

Hi All,

I have query in access, where access can switch to other file if data is not available

Currently I am performing this activity using Iferror and Vlookup function in excel where in case of error Iferror switches another table and try to match the data.

Can we do similar activity in Access?

Thanks & Regdards,

Sanket

 

[jackd]

You may be able to achieve the same functionality in Access, but those functions do not exist in Access.