How do I get a percentage of randomly selected records?

[Guest]

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.

 

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