sorting duplicates by date and...

[toshog]

hi everybody,...

i need help to make the following script:

1. find all the duplicate records - this i know how...

2. delete all the duplicates but keep the one with the most recent date...

3. if all the duplicates have the same date keep only one...

any help will be appreciated.... thanks...

[toshog]

soooo??.....

[Kurt Knippel]

Once you have found all the records that are duplicates you need to omit the records that you wanna keep. I would first sort by something that would identify the record and its duplicates (Account Number or something) then sort by your date. Now you need to loop through the records and omit the one with the most recent date. Once done, you will have your set that you can delete.