How to Check for Duplicates?

[SinCity]

I have two different tables (Table1 and Table2) that have the same
column in each (Name). Is there an easy way to check for duplicates
between the two tables?

 

[Jeff Boyce]

Click on the New (Query) toolbar button.

Select the "Duplicates..." query and follow the wizard's instructions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Granny Spitz via AccessMonster.com]

Is there an easy way to check for duplicates
between the two tables?

Write this query and save it:

SELECT [Name]
FROM Table1
UNION ALL SELECT [Name]
FROM Table2;

Now use the query wizard to build a "find duplicates" query. By the way,
Name is a reserved word so you'll avoid bugs by not using it to name columns.