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???
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.