C
carl
I have a table named Table1 that has 200,000 records. Is there a way to
randomly select 40,000 records from this table ?
Thank you in advance.
randomly select 40,000 records from this table ?
Thank you in advance.
carl said:I have a table named Table1 that has 200,000 records. Is there a way to
randomly select 40,000 records from this table ?
I have a table named Table1 that has 200,000 records. Is there a way to
randomly select 40,000 records from this table ?
Thank you in advance.
John said:I have a table named Table1 that has 200,000 records. Is there a way to
randomly select 40,000 records from this table ?
Thank you in advance.
You can use the Top Values property of a query, with help
from a little VBA. Put this little function into a Module:
Public Function RndNum(vIgnore As Variant) As Double
Static bRnd As Boolean
If Not bRnd Then
'Initialize the random number generator once only
bRnd = True
Randomize
End If
RndNum = Rnd()
End Function
Then add a calculated field to your Query by typing
Shuffle: RndNum([fieldname])
in a vacant Field cell, where [fieldname] is any field in
your table - this forces Access to give a different random
number for each record.
Sort the query by Shuffle, and set its Top Values property
to the number of records you want to see.
John W. Vinson said:I have a table named Table1 that has 200,000 records. Is there a way to
randomly select 40,000 records from this table ?
Thank you in advance.
You can use the Top Values property of a query, with help
from a little VBA. Put this little function into a Module:
Public Function RndNum(vIgnore As Variant) As Double
Static bRnd As Boolean
If Not bRnd Then
'Initialize the random number generator once only
bRnd = True
Randomize
End If
RndNum = Rnd()
End Function
Then add a calculated field to your Query by typing
Shuffle: RndNum([fieldname])
in a vacant Field cell, where [fieldname] is any field in
your table - this forces Access to give a different random
number for each record.
Sort the query by Shuffle, and set its Top Values property
to the number of records you want to see.
carl said:Thanks Marshall and John.
I am not an experienced Access person and have some trouble coming up with
the query that you recoomended. Here's what I have - it does not seem to
produce the result I need - a list of 40000 randomly selected items.
SELECT TOP 40000 RndNum([GroupName]) AS Shuffle, *
FROM Table1
ORDER BY Rnd(1);
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.