Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Delete Query

Status
Not open for further replies.

Gootz11

Technical User
Jul 7, 2003
14
US
I have a query that randomly selects 87 records from a table, is there a way that every time i run this query those 87 records are deleted from the original table so they can't be selected again??? Please Help!!!
Thanks
 
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???

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top