From: Marshall Barton on
carl wrote:

>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, *
>FROM Table1
>ORDER BY Rnd(1);

SELECT TOP 40000 *
FROM Table1
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]
First  |  Prev  | 
Pages: 1 2
Prev: error
Next: Iif Statement Problem