Select Random Record 1

[bigjohnxx]

Periodically, I need to review 20% of the data to check for data entry errors. Is there a way to create a query to return a percentage of total record of a table in random?

Thanks in advance.

 

[HitechUser]

bigjohnxx,

This may have what you need. If not just use DLookUp with a count * (times) your percentage, then use this example. Sorry I have not used it.

Random Records

I hope this helps....

 

[PHV]

SELECT TOP 20 PERCENT * FROM yourTable
ORDER BY Rnd(yourTable.NumericFieldName)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[bigjohnxx]

This is what I needed. Great forum and thanks!