Digital Workshop

I am sure this must have been rasied before but I cannot locate any gen.
Does anyone have a procedure or template which I can follow to create a quiz which selects questions at random from an Access database. I would be creating my own quiz pages rather than using the Quiz Wizard. It would be even better if the procedure would include a filter action such that no question is asked twice. Your help, as always, would be really much appreciated. I'm using Opus XE5.14
Regards
John
p.s. My sympathy goes out to anyone who has friends, relatives and collegues affected by the Hurricane Katrina

Create a list (an array is easiest) of random numbers (in the range 1 to the number of questions in the database). As you generate each random number check the previous entries in your list for a duplicate and if you hit one, generate a new random number and start the duplicate check again.

When you have the list, just pull those questions from the database (go through it one record at a time checking the current index against all the elements of the list).

Hope that makes some sort of sense.