Yes, run the randon selection process and update a boolean field in your table to Yes. Then select these records for your processing as well as run another query to select those flagged as Yes and delete them.
Post back with questions.
Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???