SELECT Otest.app,Otest.id,Otest,fname,Otest.bday; dup.numrec; FROM; mainbase!otest; INNER JOIN (select fbobname, COUNT(*) as numrec FROM otest group by fname HAVING COUNT (*)>1) ; dup on otest.fname=dup.fname on otest.id=dup.idi only added the Otest table and dup in the designed