random sample

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database of employees. Is it possible to extract 30% of them, at random, for the purposes of creating a random sample.
 
Yes, You need to fill a Table w/ 30% of your employees. IE, if 200 employees
then 60 unique selections. If you want, I'll find some code that shows that

HTH - Bob
 
I have a database of employees. Is it possible to extract 30% of them, at random, for the purposes of creating a random sample.
Click to expand...

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.
 
Back
Top