Random order of questions

J

Jeanne Conroy

Hi!

I asked this question a few weeks ago but the answer disappeared before I
could save it.

I have a database of test questions and multiple choice answers numbered 1
through 45. I want to be able to present the questions in random order each
time the test is given. How can I do this?

JeanneC
 
A

Allen Browne

Go to groups.google.com and use the Advanced Search to search in:
microsoft.public.access.*
for your answer.

It would have involved using a query with:
ORDER BY Rnd([QuestionID])
 
Top