How do I get a percentage of randomly selected records?

N

nikami78

I need to create an audit report with randomly selected records from a table.
Is there a criteria that would randomly select a percentage of a table's
records?

I'm using Access 2003.
 
A

Allen Browne

Assuming a primary key field named ID (type Number or AutoNumber):

SELECT TOP 10 PERCENT tblClient.*
FROM tblClient
ORDER BY Rnd([ID]);

Don't forget to Randomize first.
 
Top