Try this query:
SELECT TOP 50 MyTable.*
FROM MyTable
ORDER BY Rnd(MyTable.MyID), MyTable.MyID;
Before running it you need to execute a Randomize statement so Rnd() does
not use a repeatable sequence.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Tom" <tm*****@nospam.please> wrote in message
news:3D*****************@newsread1.news.pas.earthl ink.net...
Say I have a field named Numbers in MyTable and the field contains 500
random numbers between 1 and 1000; no duplicates. How do you write a query
to randomly return 50 records with no duplicates from the 500 records in
the
table?