esn wrote:
Also, I just noticed Access redraws the random number every time I
click in one of the records of the query results, and seems to
struggle with recalculating (often tries to display the original and
new values at the same time in the same cell). Is this query just
recalculating and that's why the records never really appear in any
sort of order?

Read this:
http://www.mvps.org/access/queries/qry0011.htm

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/201005/1