If duplicate records can be identified by a duplicate value in a specific field, you can perform a find and put the ! operator in that field. Then sort the found set produced by this find to put the duplicate values next to each other. This will work as long as the field where you put the ! is not a text field with return characters in it.
Thank you so much for your reply.
I have two fields: Name and Address need to be identified. Should I put the ! operator in both Name and Address fields? It's been a long time since I use FileMaker last. I am not familiar with the newer version of Filemaker 11. I will figure it out if they are text fields or not.
Thanks again. I appreicate your help.
I would assume that it is name and address combined that identifies which records are duplicate. If so, define a calculation field that combines the two fields with an expression like this:
Name & " " & Address
Then put this field on your layout and use ! in it in a find followed by a sort.