>>>>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 as FName, COUNT(*) as numrec FROM otest group by FBobName 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

See commented part in your query and minor corrections. After that I expect it to work.