Jump to content

Finding Duplicates in a Field


CatLady03
 Share

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

Recommended Posts

I have looked and cannot find anything on identifying duplicates in a given field.

I have a field called Symbol. I'm trying to isolate those symbols that only appear once. Many appear twice and I want to print a list of symbols that only appear once.

Can anyone help?

Thanks!

Link to comment
Share on other sites

Oh geez! Thanks for the reminder, Jeff. I knew I had seen that somewhere...I just didn't recall where. It's the little things. Thanks, that really helped.

Now, I have one other question pertaining to the duplicates. Can you recommend a quick way to delete the duplicate records? I've been thinking on it, but no luck so far.

Any suggestions would be greatly appreciated!

:thankyou:

Debbie

Link to comment
Share on other sites

Go to Filemaker.com and choose "Support" and then "Knowledge Base". Once you're there, type in "delete duplicate" and you'll have a buffet of answers.

I think the one's that say something like "Deleting Duplicate Records Using a Self-Join Relationship" are the fastest. Maybe someone else on this forum can verify that.

:)

Link to comment
Share on other sites

This topic is 5613 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
 Share

×
×
  • Create New...

Important Information

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