How do I get a percentage of randomly selected records?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Back
Top