nevermind, I got it...
-- Sam
-Original Message-
From: Sam Roach [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 18, 2003 1:22 PM
To: CF-Talk
Subject: OT: MS Access random records
I need to grab a random 25000 records from a database, no dups.. I found
some code online and modified
1. select distinctrow old_table.name into new_tableA
2. create new_TableB
3. change your random record selector to loop 25500 times, randomly selecting a record
from new_tableA, inserting it into new_tableB and
deleting it from new_tableA.
ô¿ô Tony
-Original Message-
From: Sam Roach
2 matches
Mail list logo