Access- Iferror functionality

sanket_sk

New Member
Joined
Dec 27, 2016
Messages
45
Office Version
365
Platform
Windows
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
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

jackd

Well-known Member
Joined
Oct 19, 2006
Messages
1,269
Office Version
365
You may be able to achieve the same functionality in Access, but those functions do not exist in Access.
 

Watch MrExcel Video

Forum statistics

Threads
1,102,565
Messages
5,487,588
Members
407,605
Latest member
PACULA

This Week's Hot Topics

Top