>>>Can you show what exactly did you write? The query as I posted (even if posted from the top of my head) should have worked just fine.


Can you tell me if this should be working (cause its not )

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.id

i only added the Otest table and dup in the designed