>>Hello All
>>so i messed up a table i had an records i enter even thou its the same can hav different client ids
>>
>>so i wrote this query
>>

>>SELECT COUNT(otest.fname) AS numrec,otest.fname,;
>>    otest.prefix,otest.bday,otest.aoonumber,;
>>   otest.id;
>>     FROM MAINBASE!OTEST;
>>GROUP BY otest.fname;
>>HAVING (numrec) >(1);
>>INTO TABLE dup
>>

>>
>>so that works fine it opens a dup table an i see like
>>

>>Numrec   fname
>>2                   peter
>>3                      james
>>

>>but im trying to link the otest table an the dup table in such a way that instead of showing one row for Peter an moving to JAmes it will show me the two rows for peter and the three for james so i can do what i need to do with them. Im fully aware i can just go in the Db an manually do it but.dont really wanna do that way. Thanks
>

>select T.*, Dup.NumRec from OTest T 
>inner join (select FName, count(*) as NumRec from oTest group by FName having count(*) > 1) Dup
>on T.Fname = Dup.Fname

also the numrec field is in DUp im getting the error 'Not a character expression'