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

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

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

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.