M
marnita F via AccessMonster.com
Hi Guys,
What I need is a way to take two tables that have customer name and address
columns and use these columns to match using any part of the data that will
match. For example sometimes the customer name might be Jack Jones and in
the other table it might be J. Jones. So is there a way to match on the
jones part of the field and ignore what doesn't match?
Thank you for any help you can provide.
What I need is a way to take two tables that have customer name and address
columns and use these columns to match using any part of the data that will
match. For example sometimes the customer name might be Jack Jones and in
the other table it might be J. Jones. So is there a way to match on the
jones part of the field and ignore what doesn't match?
Thank you for any help you can provide.