Finding Duplicate Entries

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

How can I filter a database to leave only instances of the same entry
more than once in column b where column a is different? That is,
where column a shows candidates and column b shows contributors, how
can I display only the rows where the same contributor made
contributions to more than one candidate. The database has over
10,000 rows in the database. There are many instances of multiple
contributions by one contributor to one candidate, but these should
only show when the contributor also made contributions to two or more
candidates.

Ken
 
How can I filter a database to leave only instances of the same entry
more than once in column b where column a is different? That is,
where column a shows candidates and column b shows contributors, how
can I display only the rows where the same contributor made
contributions to more than one candidate. The database has over
10,000 rows in the database. There are many instances of multiple
contributions by one contributor to one candidate, but these should
only show when the contributor also made contributions to two or more
candidates.

Ken
Click to expand...

Probably the simplest way is to create a new table by copying the
*design only* of your current table, and creating a unique Index on
these two fields. There are a couple of ways to do so: if your table
does not currently have a Primary Key, ctrl-click both fields and
press the "key" icon; if it does, use the Indexes tool (looks like
lightning hitting a datasheet) to create a two-field unique index.

Then run an Append query appending from your current table into this
one. You'll get a warning message "xx records were not added due to
key violations" - those are the unwanted dups.
 
Back
Top