>>>>I already re-wrote it correctly for you. Why did you write it incorrectly again?
>>>
>>>Cause i had it before an when i used one "ON" it keeps tellin me not a character expression
>>
>>Ok, fix the query first the way I wrote it.
>
>ok i got this...exactly
>
>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
>
Right and this query should work.
If it's not broken, fix it until it is.
My Blog