I want to establish a list of random numbers, corresponding to a database question list. The problem is that I may have 10 questions, but non-consecutive numbers (thanks to the Access autonumber field), and hence this could take some time as the number of questions increases.

Usually, I would just keep generating random numbers in the range of lowest to highest number, check if a question exists for that number, and then check if that number has already been put in the list (or perhaps those last 2 in reverse order). What would be a faster way? This is for an internet thingy, so speed is the key here. I am building these routines into a .dll for a set of ASP to access.

-RJ