troubleshooting Question

Linking Access Tables with Partial Item Matches

Avatar of jack3_99
jack3_99Flag for United States of America asked on
Microsoft OfficeMicrosoft AccessMicrosoft Applications
2 Comments1 Solution417 ViewsLast Modified:
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
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros