Gilberto Sanches
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.
So when we insert a record, another field takes that info automatically, searches for something related to it & returns that related info if found.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
there is no vlookup function in Access environment.
DLookup Function
https://support.office.com/en-us/article/dlookup-function-8896cb03-e31f-45d1-86db-bed10dca5937