>>>>>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 fname as FName, 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
>
>See commented part in your query and minor corrections. After that I expect it to work.

oh oh i re wrote it wrong :(did hav the id)

SELECT Otest.app,Otest.id,Otest,fname,Otest.bday;
dup.numrec;
FROM;
       mainbase!dup; && added this 
otest; && added this 
INNER JOIN (select fname as FName, COUNT(*) as numrec FROM otest group by FName HAVING COUNT (*)>1) ;
dup on otest.fname=dup.fname  on otest.id=dup.id

an it still tells me unrecognized key words