See my 3 queries I just posted.
>it deleted ones that do not have duplicates. i would like to keep any records that do not have duplicates.
>
>brenda
>
>
>>select keyid, lastname+firstname customer, count(lastname+firstname), max(add_date) from mytable group by 2 having count(lastname+firstname) > 1 into cursor crsTemp
>
>>delete from mytable where lastname+firstname in (select customer from crsTemp) and keyid not in (select keyid from crsTemp)
Mark McCasland
Midlothian, TX USA