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.