SELECT TOP N fieldlist
FROM tablename
ORDER BY Rnd(numericfield);
where
N is the number of records you want to select
fieldlist is the fields you want in your recordset
tablename is of course your table
numericfield is some numeric field in your table
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.