If you have a primary key in your table, you can run "totals" queries
and count the number of unique records with the same data.
Use the query designer, and right click in the field definition area and
select the summation symbol (Greek Epsilon). This adds the totals line
to the query.
Add the table's primary key to the table and select "Count" under the
totals list. Then start adding fields you would like to check for
equality. For instance, if I had a "people" table, I might add First and
Last name fields.
Make sure that the non-primary key fields are totaled as "group by".
Run the query... it will return the count of records with identical
first and last names... any first/last name combination with a count of
more than one is repeated.
Luke
