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, *
ORDER BY Rnd(Len([CLM]![CLAIM_NO])) DESC;
Any help would be greatly appreciated