Link to home
Start Free TrialLog in
Avatar of Gilberto Sanches
Gilberto SanchesFlag for Suriname

asked on

Alternative of vlookup in Access 2016

What options are there to have something like a vlookup in Access 2016 database?

So when we insert a record, another field takes that info automatically, searches for something related to it & returns that related info if found.
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

are you referring to DLookup function?

there is no vlookup function in Access environment.

DLookup Function
https://support.office.com/en-us/article/dlookup-function-8896cb03-e31f-45d1-86db-bed10dca5937
ASKER CERTIFIED SOLUTION
Avatar of Gilberto Sanches
Gilberto Sanches
Flag of Suriname image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I was wondering what alternative there are, maybe custom expressions or vba stuff.
yes, you can. but you need to evaluate if it's necessary to implement that.