Sort Order -- Random?

[Greg Brady]

Is there a way to return a random sort order from a query?

 

[Allen Browne]

Assuming a numeric primary key named "ID", use this in the ORDER BY clause
of your query:
ORDER BY Rnd([ID])

Note that you need to issue the Randomize statement before running the
query.

(The Rnd() function does not actually do anything with the ID value, but if
you do not pass the value in, the query optimizer doesn't bother calling the
function again at every row.)