>I have table with 5 or so fields and I am trying to eliminate records where there are duplicates based on the field UPIN. The whole record isn't duplicated but the UPIN value is. So the name,UPIN,credential would/could be duplicated but the zip,state, and specialty might be different. I need only unique (DISTINCT) records based on the UPIN field but I need the whole record.
>Hope this isn't clear as mud.
>Thanks,
>Eric
Eric,
If only UPIN is the field to determine duplication how would you decide which one has correct data for you ? A simple SQL with grouping would return distinct UPIN values but it has little chance that other fields are what you want (last record entered per UPIN).
Maybe a classical xbase approach would work for you best (order by UPIN, scan while UPIN is same and decide what should other field content be).
Cetin