Any RANDOM function in Access 2002

  • Thread starter Thread starter Winston
  • Start date Start date
W

Winston

Hello everyone,

Is there any function in Access 2002 that can be used to
select a fixed number of records RANDOMLY?

Any answer will be appreciated?
 
Is there any function in Access 2002 that can be used to
select a fixed number of records RANDOMLY?
Click to expand...

Sorry about the blank answer... moused the wrong button!

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