Hi guys,
I have a table whose unique id is a 'running' number (recno) but it has other details (village, compound, house and individual's sequential code). I'm writing code to search for duplicates in the table but I've been stumped coz the recno is different if an individual appears more than once. I can only get duplicates if I check for village+compound+house+sequential code. How do I go about this? I'll be grateful for all the help I can get.

Richard.