Duplicates

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

I wish to search for duplicates in one field but in 21 tables. The field has
a ten digit number which could reoccur in more than one table I need to know
how many duplications of the number & in which tables. Each table has over
2500 rows.

Thank You

Bruce
 
Create a temporary query for each table with the number
field and any other field you want. Insert a text
expression listing the name of the table.

Union the queries: copy the SQL statements of each query,
but delete the semicolon on all of them but the last, and
Add the word "UNION" before the word "SELECT" at the
beginning of each statement.

Save the new union query, iconized by two rings, and
delete all those temp. queries.

Run the query wizard and use "find duplicates" wizard. At
the last step, be sure to view before you make design
changes (ACCESS has a little glitch here...).

This method will work, but it is very odd to have 21
tables that could have the same data in the fields. It
sounds like you might have some design issues.

If you have any questions, feel free to email at
(e-mail address removed)

Signed, CONNECTTODANIEL
Access Developer for DBC/FBC/BCM
 
Back
Top