you can randomize any given table by throwing the data into an array and randomizing THAT. It's certainly not novice-type coding, so I would start with google here:
http://www.google.com/#sclient=psy&h...1&pf=p&pdl=300
I think people scoff at the method that those articles are using, but I can't remember why. I don't think rnd() by itself can always be trusted. It's been a while since I've researched seeding.
so you'd probably want:
Code:
select AutonumberField, field2, field3 .......
ORDER BY rnd([autoNumberField])