Link to home
Avatar of jack3_99
jack3_99Flag for United States of America

asked on

Linking Access Tables with Partial Item Matches

We have a table (tblItemList) that has incomplete UPC codes.  I want to match this table with a table (tblMasterList) that has complete UPC Codes.

I want the tables to join any time there is even a partial match.  For example, if the partial UPC Code contains  37384000, it should match to 20737384000213, 20737384000107, 20737384000060, etc.  

Attached is an example of the database.  The query qryItemMatch displays all of the records in tblItemList and only those records that match exactly to tblMasterList.   I tried to include wildcards such as the following; however, then nothing matched.

FROM tblItemList LEFT JOIN tblMasterList ON ("*"& tblItemList.PartialUPC &"*") = tblMasterList.UPC

I appreciate any help you can provide.

Thank you,
Jack
Example.mdb
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of jack3_99

ASKER

This is perfect!  Thank you for your help