>>>>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
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.
If it's not broken, fix it until it is.
My Blog