Hello -

Thank you for the reply, however the query you wrote is not going to help me. What I want is finding all records who have same first name, last name but more than one PCP. Each indivitual should have one PermNO, the list you gave me finds duplicates. In our case, one person might have one or more records, but he/she should always have same PermNO no matter what.