random sample

  • Thread starter Thread starter JayL
  • Start date Start date
J

JayL

All -
I have a table with just over 100,000 records. I need to select a random
sample of 10% and isolate that sample somehow.
I remeber doing this in Excel using the @RAND function but I don't have a
clue where to begin in Access.

TIA
Jay
 
criteria:

rnd([key])<0.1

rnd() will give a different random number each time it is called, but Access
will optimise the query to only call it once, hence the need for a variable
argument to ensure that it is called for each line.
 
Back
Top