Partial field matches in a report

I have two tables that I have already made the correct relationships. Both
tables contain a list of part numbers plus other relevant info. I can create
a report that shows the part numbers from table 1 that match the ones in
table 2 which are an exact match. How do I create a partial match? I want the
report to pull the part numbers from table 1 that are at least a partial
match to the part numbers in table 2. Thank you very much.

You need to define what a partilal match is and maybe we can help you.

Steve



"iB4e" wrote in message
...
I have two tables that I have already made the correct relationships. Both
tables contain a list of part numbers plus other relevant info. I can
create
a report that shows the part numbers from table 1 that match the ones in
table 2 which are an exact match. How do I create a partial match? I want
the
report to pull the part numbers from table 1 that are at least a partial
match to the part numbers in table 2. Thank you very much.