April 20, 200916 yr Newbies 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
April 20, 200916 yr Try going to record number 501 and omitting 5,500 records, or rather Get (FoundCount) - 500.
April 20, 200916 yr Go to Record [501] Omit Multiple Records [Get ( FoundCount ) - 500] *Edit sorry Michael didnt see your reply. Edited April 20, 200916 yr by Guest
April 20, 200916 yr Author Newbies Thank you so much for your help! It was so obvious... Thanks, Steven
Create an account or sign in to comment