Finding duplicates and omitting

[original6]

Hi,

I hope someone can help. I have database that has contact info for bowlers in a bowling center. If they bowl in multiple leagues in a year, or for that matter, across multiple years, when I do a find on the email field to find all the people who have supplied an email, I may get the same email address multiple times. I know how to find duplicates, but how do you find duplicates and eliminate all but one occurence of that email address? I'm stumped.

Thanks for any help you can give me.

All the best,

Jim

[Lee Smith]

Take a look at this demo by Ray J. Cologon Find Unique and see if this doesn't help.

Lee