Beeyen
asked on
Vlookup in Access
Good Day Experts,
I have never executed a Vlookup in Access and was wondering if I could get some assistance.
I have two tables FACMatch and CSWMatch, I would like to compare or match any cert num in FACMatch with cardholderid in CSWMatch. I also need to remove the last two digits of the cardholderid before performing the Vlookup. For your review I have attached the accdb. Thank you for any assistance you can provide.
CSWMatch.accdb
I have never executed a Vlookup in Access and was wondering if I could get some assistance.
I have two tables FACMatch and CSWMatch, I would like to compare or match any cert num in FACMatch with cardholderid in CSWMatch. I also need to remove the last two digits of the cardholderid before performing the Vlookup. For your review I have attached the accdb. Thank you for any assistance you can provide.
CSWMatch.accdb
The equivalent function in Access is named DLookup(). However, in most cases a join is more efficient.
ASKER
Could you be more specific please? Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
However, in most cases a join is more efficient.
Not to mention that it would also be more portable (considering that the MS SQL Server topic was included in this thread).
Not to mention that it would also be more portable (considering that the MS SQL Server topic was included in this thread).