Randomizer

C

Chris Apperson

I have a table with "Employee Name", "Loan
Number", "Description" "Etc"... Fields. Each employee may
have 100 loans in their name that they processed. I need
to set up a query or VB Script that will Randomly pull 5
loans per emplyee to do a Quality check on. How do I do
this?

Thanks,

-Chris
 
M

Michel Walsh

Hi,



ORDER BY on a generated a random value for each record, keep the top 5.


SELECT TOP 5 *
FROM myTable
ORDER BY Rnd( NumericalNotNullFieldOfYourTable )



Hoping it may help,
Vanderghast, Access MVP
 
Top