Finding Duplicate Fields

[vandehey]

This will hopefully be an easy one, but I search around and couldn't find the answer. I have a DB w/ 20,000 + records. I want to find all records that have duplicate values in a certain field. Say I have a field called 'names'. I want to find all records that have the same value in the name field.

I hope that makes sense, here is another illustration. Say there are many of records w/ Jane, Jack, Jeff, Karen in the name filed. I want to do a find, listing all records that are NOT unique in a given field. In this example, it would list records containing Jane, Jack, Jeff, and Karen. Can anyone help me out?

Thanks!

[-Queue-]

Entering the exclamation point in a field while in find mode will find all records with duplicate values.