[AccessD] A2003: Random order

Steve Erbach erbachs at gmail.com
Wed Oct 26 13:36:56 CDT 2005


Gustav,

Hmmm, are you talking about something like this?:

SELECT QID AS TestQID, RAND([QID]) AS RndID
FROM OrgQuestions
ORDER BY RAND([QID])

The RAND() function in SQL Server has the same limitation that the Access
RND() function does, though; that is, the "random" number that's generated
in the query will be the same for every record, won't it?

Steve Erbach
Neenah, WI

On 10/26/05, Gustav Brock <Gustav at cactus.dk> wrote:
>
> Hi Steve
>
> Why not make that table a two-field table.
> Fill the other field, say RndID, with random numbers when the table is
> created.
> Now read from the table QID ordered by RndID.
>
> /gustav
>



More information about the AccessD mailing list