Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Find complete record duplicates

Find complete record duplicates

Find complete record duplicates

I have table where each record contains many fields....30+. I need to find duplicates comparing all fields. Using the Find Duplicates Query will only allow 10 fields to be examined. I need the complete record, all fields to be examined.

Any suggestions....please.

RE: Find complete record duplicates

  • Make a query with the 10 fields
  • Examine the joins with the 10 fields in design or SQL view
  • Add the other fields
If you have Nulls in any field, this may cause issues since Nulls will not join with Nulls.

Hook'D on Access
MS Access MVP

RE: Find complete record duplicates

Alternative syntax, in design view:
- select fields where you need to find duplicates,
- in query properties mark "unique values" (resulting "SELECT DISTINCT" in query sql),
- add non-visible field with expression: "N:count([AnyField])", with condition: >1.
For conversion to unique records skip last bullet.


RE: Find complete record duplicates

I like combo's solution since it is much simpler and your query involves only one table.

Hook'D on Access
MS Access MVP

RE: Find complete record duplicates

Thank you both. Once I get a new data load...about a week from now...I will give this a try. If it works, as I expect it will, Stars will be given.

Thanks again,

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close