Need help with making 100 unique random sample selections from access database

[jdlee]

Just in case someone comes across this, the method linked below worked for me.

Populate array with random, unique numbers

Not exactly following the steps you wanted, but this way might be a better solution to get the same outcome you want. I created an activity that receives a datatable as an in argument, randomizes it by performing a fisher-yates/knutes shuffle, and outputs the randomized datatable as an out argument. Knutes_Shuffle.xaml (11.7 KB) This might be a better way to go about it as it can be used for many things. In your case, you’d simply pass in the table to be randomized, then grab ‘n’ rows, where …