Here's what I'm looking to do and I can't figure out how to do it.
I have 2 tables in an access database. The user will enter a part # that is listed in table one. Many specifications are also listed with the part # in Table one. Then I want it to compare all the specs from the part # in table 1 and select the best matching part in table 2. There are about 30 difference columns of specs listed. Both tables are set up the same way with the same columns and everything. Is there anyway to do what I am asking.. I'm hoping it's clear.

Thank you,
Corey