find records that exist in one table and do not exist in another 1

[ringadeal]

I have 2 tables with almost identical data except that one has several extra records. How can I easily locate these extra records based on the records of the other table which does not contain these extra records?

 

[genomon]

In the query tab, click on "New", then "Find Unmatched Query Wizard". Follow the instructions...

"Before you criticize someone, you should walk a mile in their shoes.
That way, when you criticize them, you're a mile away and you have their shoes."

 

[CaptainD]

I have 2 tables with almost identical data except that one has several extra records. How can I easily locate these extra records based on the records of the other table which does not contain these extra records?

If they have a common field you could do a "Not In" select statement.

You could post more information on your tables

 

[ringadeal]

Would the syntax be:

Select table1.field1 from table1 WHERE table1.field1 Not In table2.field1

thanks for your assistance

 

[CaptainD]

Field1 would need to be unique to both table so if Field1 is an "Autonumber Primary key" then it might not be accurate.

Something like this:

SELECT sLastName
FROM Table1
WHERE sLastName Not In (SELECT sLastName FROM Table2);