Randomly order output for multi-choice questions

  • Thread starter Thread starter andrewmp
  • Start date Start date
A

andrewmp

Guest
I have a db that contains a large number of multichoice questions, with 5 options for possible answers. I use a form to create the MCQs and answers, BUT the correct answer is always the first option. I need a way to randomise the order of the output from the tblQuestions to make an exam paper. Both the questions and answers are stored in the same table.
 
Do a search on Random or RAND function...you should get several examples...here is one that should help you...

Random
 

Users who are viewing this thread

Back
Top Bottom