[AccessD] A2003: Random order

Gustav Brock Gustav at cactus.dk
Wed Oct 26 13:42:36 CDT 2005


Hi Steve

Yes, but follow the guide from Shamil for the SQL Server spedifics.
You can use that also if you need to create the temp table.

/gustav

>>> erbachs at gmail.com 26-10-2005 20:36 >>>
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