Randomizer

  • Thread starter Thread starter Chris Apperson
  • Start date Start date
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
 
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
 
Back
Top