search for

[carol]

is there a way to query and search for one table's field
text string in another table's text field to identify
similar matches. in other words, to return all similar
matches that contain similiar text as in following example:

table a, company field value "Applewood Crafts" to search
and return in table b, company field value "Applewood
Crafts Inc." or "Applewood Crafts Incorporated"

table a, company field value "Iron Creations" to search
and return in table b, company field value "Iron Creations
Co." or "Iron Creations Company"


table has 150 different company values so can't do one at
a time. help!!

thx!

 

[Brian Camire]

You might try a query whose SQL looks something like this:

SELECT
[table b].[company],
[table a].[company]
FROM
[table a],
[table b]
WHERE
[table b].[company] LIKE [table a].[company] & "*"

This will return all combinations of company names in table a and table b
where the company name in table b starts with the company name in table a.

Note that for a given company name in table b, there may be more than one
record in table a that "matches".