random selection

  • Thread starter Thread starter Chris Large
  • Start date Start date
C

Chris Large

Hi

You need to create a query something like this :-

SELECT TOP 50 YourTable.*
FROM YourTable
ORDER BY Rnd([YourTablesAutoNumberField]);

Regards

Chris
 
Thanks
-----Original Message-----
Hi

You need to create a query something like this :-

SELECT TOP 50 YourTable.*
FROM YourTable
ORDER BY Rnd([YourTablesAutoNumberField]);

Regards

Chris

-----Original Message-----
I would like to preface this by stating that i am brand
new to Access. I have a project where I need to
automatically, every work day, select 50 people randomly
(based on a numerical value) from an existing Access
database, and am wondering the best way to go about it.
Thanks
.
Click to expand...
.
Click to expand...
 
Back
Top