From: Marshall Barton on 12 Mar 2010 15:07
>Thanks Marshall and John.
>I am not an experienced Access person and have some trouble coming up with
>the query that you recoomended. Here's what I have - it does not seem to
>produce the result I need - a list of 40000 randomly selected items.
>SELECT TOP 40000 RndNum([GroupName]) AS Shuffle, *
>ORDER BY Rnd(1);
SELECT TOP 40000 *
ORDER BY RndNum([GroupName])
There is no need to put the RndNum([GroupName]) AS Shuffle
in the select list and it would be meaningless to your
MVP [MS Access]