Random sample selection

[RJN]

Hi

I have to randomly pickup records from database for some quality check
of data. Say the data base has about 1000 records, I have to randomly
select about 50 records. Can someone suggest me some simple Random
generator algorithm to do this?

Thanks

RJN

 

[Chris, Master of All Things Insignificant]

From the Random Function in help file:
Dim MyValue As Integer
Randomize ' Initialize random-number generator.
MyValue = CInt(Int((6 * Rnd()) + 1)) ' Generate random value between 1 and
6.

There is also a Random Class that will do this for you. I haven't used it
but it looks trivially simple.

Chris

 

[Herfried K. Wagner [MVP]]

I have to randomly pickup records from database for some quality check
of data. Say the data base has about 1000 records, I have to randomly
select about 50 records. Can someone suggest me some simple Random
generator algorithm to do this?

'Random.Next' -- F1.