I don't know the syntax off the top of my head, but how about something like...
Copy the table to a new table (so the original is not irrevocably fragged)
NumRecords = # records in this table
TenPercent = (NumRecords * .1) \ 1 ' Use this as the outer limit of your loop
for K = 1 to TenPercent
RandRecord = a random number between 1 and NumRecords
Go To RandRecord 'go to that row
Pick up relevant data, store to array (or write to a new table)
Delete row #RandRecord 'to prevent this record from future selection
NumRecords = # records in this table 'reset this number to reflect
'remaining number of records
next K
jaYPee <hi******@yahoo.com> wrote in message news:<a7********************************@4ax.com>. ..
anyone know how can i get a 10% random records out of 2000 records?
2000 is only an example and it will vary anytime.
i want to create a report out of this 10%
thanks in advance