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