I want to randomly order a recordset of students from a student demographic table.

Then I want to randomly order those same students in another query in the exact same random order

RAND() stinks - nothing like VB RND...

Code:
SELECT RAND(),* from sometable
gives a column of random values that are all the same - RAND() must be evaluated prior to the SELECT and the value populated throughout the recordset. What a useless function...