Like Match Query?

[Tony Feole]

Hello,

I am currently working on a query that uses two tables from two diffrent sources. The first table contains all of our Customers Name and Address's and the second table is a list that was provided by the Federal Goverment (Denied Person's List) which also has Name and Address information. My problem is that there is no "Key Identifier Value" between the two tables.

Question: Is it possible to create a "like" query that will look for similiar values between the two fields and bring back the results? I understand that this would not be an exact match or science but it would be a start. Any help would be much appreciated.

--
Regards,

Tony Feole
Invnentory/Distribution Analyst
Ormco Corporation

 

[GVaught]

As an interim to your dilemma you could create a Union query that would take
the structure of your customer table and structure of the Fed's table and
combine into one query to at least get a possible list of duplications for
comparison. However, the structure of the fields used must match. Thus. if
you list Lastname, Firstname, Address with datatypes/size as: Text/30,
Text/30, Text 100; then the Fed table must have that same structure.

Also the number of fields listed in the Select statement must match the
number of fields in the Fed's table.

Structure:
SELECT Lastname & " " & FirstName AS Fullname, Address FROM tblcustomers
Order by Fullname

UNION

SELECT Lastname & " " & FirstName AS Fullname, Address FROM tblFed
Order by Fullname

This was typed from the top of my head and may need some tweaking to correct
syntax.

Hello,

I am currently working on a query that uses two tables from two diffrent

sources. The first table contains all of our Customers Name and Address's
and the second table is a list that was provided by the Federal Goverment
(Denied Person's List) which also has Name and Address information. My
problem is that there is no "Key Identifier Value" between the two tables.

Question: Is it possible to create a "like" query that will look for

similiar values between the two fields and bring back the results? I
understand that this would not be an exact match or science but it would be
a start. Any help would be much appreciated.