Actually, it's quite simple.
Suppose I had a table called Table1 with a numeric field called Table1_ID
and I wanted 10 random records. The query would look like this:
SELECT TOP 10 * FROM Table1 ORDER BY Rnd(Table1_ID)
Ordinarily, the TOP query would select 10 records as determined by values of
the field you are sorting on (the Order By clause), but when you order on a
random number (as created by the Rnd function seeded with a numeric value
from the record), the net effect is a random sampling.
--
--Roger Carlson
MS Access MVP
Access Database Samples:
www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L