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

[jdlee]

I am a complete noob with almost no experience with SQL or VB, so the one solution i’ve found online doesn’t make sense to me. Could anyone please help me figure out how to make a random sample selection of 100 rows?

So far i’ve been able to connect to the access database file and execute a query to export all columns and rows to an excel file, but I’m worried that i’ll hit the excel row limit if I go down this path.

In Access the query SQL view is:
SELECT DISTINCTROW TOP 100 Rnd(Len([CLM]![CLAIM_NO])) AS Expr1, *
FROM CLM
ORDER BY Rnd(Len([CLM]![CLAIM_NO])) DESC;

Any help would be greatly appreciated

[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 …