I already re-wrote it correctly for you. Why did you write it incorrectly again?

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