Random Sample of Data

[Helena]

Hi,

I have a query that returns 10,000 records I want to do a
random sample across these records to get just 100
records selected evenly across the whole batch.

Does anybody know how to do this in access...is it even
possible?

Thanks

 

[Joan Wild]

Have a look at
http://www.mvps.org/access/queries/qry0011.htm
Create a query that returns Random records