random selection

[Chris Large]

Hi

You need to create a query something like this :-

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

Regards

Chris

 

[rekowski]

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
.

.