Jump to content

Find duplicates


This topic is 6448 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi there. I have a contacts database with names of our consultants and clients. If I just perform a "!" find, it doesn't find the duplicates. I don't know if I need to create a self-joining relationship just to find duplicates with the same FirstName and LastName. Is there an easier way to do this? The "Identifying duplicate values using a self-join relationship" section in the help menu is confusing to this newbie.

Thanks.

Link to comment
Share on other sites

I would create a calculated field to concatenate all the fields that determine what a duplicate is. In you case I assume it's first name and last name. So, make a new calculated field with the formula:

FirstName & LastName

Then you can do a search in this field using the ! character.

Link to comment
Share on other sites

I also have the same problem. I imported a database oh about 1.000 clients and some of them occurs more then one.

I need a script witch can find i.e a duplicate of a customers number witch always are the same.

So as a short example:

if more then one record found with customer number 1234, display

I hope that explains what I am looking for :D

Link to comment
Share on other sites

This topic is 6448 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.