Deleting Omitted Found Set

[steven723]

I need help to be able to delete the first fixed number of records in a found set. For Example I have a total of 70,000 records. When I do a find on a certain field it displays a found set of 6,000 records. I need to be able to delete the first 500 records in this found set of 6,000. When I used the 'Omit Multiple' and enter 500 it omits the first 500 records of my found set but when I select to 'Show Omitted Only' it then show the 500 records I want to delete AND the other 64,000 records that I do not want to delete.

Does anyone know how I can just delete the first 500 records in a found set efficiently as possible as I need to do this procedure over and over again many times.

Thanks, Steven

[comment]

Try going to record number 501 and omitting 5,500 records, or rather Get (FoundCount) - 500.

[mr_vodka]

Go to Record [501]

Omit Multiple Records [Get ( FoundCount ) - 500]

*Edit sorry Michael didnt see your reply.

Edited April 20, 2009 by Guest

[steven723]

Thank you so much for your help!

It was so obvious...

Thanks, Steven