Random sorting of fields in records

[Taffski]

I've created a database of 500 multiple choice questions with 4 x possible
answer options per question (A - D). At present each correct option is
Answer A.
I have added a module to randomly select a fixed number of questions from
the question bank - each time the query is run a different 'exam' report is
created.

What I now need to do is (a) scramble the answers to each question each time
a new 'exam' is created and (b) report the correct answers at the end of the
report.

I'd be grateful for some help with this.

Taffski

 

[Jeanette Cunningham]

hi Taffski,
there is a sample database that does a couple of different types of
scrambling on Rogers Access Library.
http://www.rogersaccesslibrary.com/

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia