I have a database of 100,000 records , I want to randomly (I known how to do
this) select say 200 records randomly , at the same time I want to delete
the randomly selected record from the original table. The random records
will be appended to a new table.

Thanks Patrick

On Mon, 2 Feb 2004 19:43:31 -0500, "CaribSoft" <v> wrote:

>I have a database of 100,000 records , I want to randomly (I known how to do
>this) select say 200 records randomly , at the same time I want to delete
>the randomly selected record from the original table. The random records
>will be appended to a new table.

You can't do it "at the same time", i.e. not as part of the same
query; but you can create a Delete query joining the two tables,
deleting all those records from the source table which match the new
table.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Hi Patrick,

Thank you for using the newsgroup and I am reviewing you post. Our MVP have
provide a approach that to select the record into a new table and then
delete from the old table the record which are in the new table. I wonder
this meet your requirement or you still have questions about it.

Looking forward to your resply! Thanks

Best regards

Baisong Wei
Microsoft Online Support
----------------------------------------------------
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.