Prev: error
Next: Iif Statement Problem
From: Marshall Barton on 12 Mar 2010 15:07
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
program.
--
Marsh
MVP [MS Access]
First  |  Prev  | 
Pages: 1 2
Prev: error
Next: Iif Statement Problem