I did a search and none of the solution posted worked for me. I'm using MS Access for database and a ColdFusion as front end. I want to be able to retreive in SQL a set of records in random order. I tried various things, like rnd(), rand() and newid().

Since rand() and newid() didn't seem to be part of MS Access it didn't work. rnd() used in a similar fashion as follows:

SELECT * FROM some_table WHERE condition = 0 ORDER BY rnd(integer_primary_key);

only worked in Access, but did not return random results in ColdFusion Page...

Anyone have any suggestions on how to randomize the order of how records are returned?