-----Original Message-----
If I make a question with 5 mutiple choice answers is
there a way to shuffle the choices so each question the
answer choices are in different order?
Thanks Rick
.
Try two tables
tblQUESTION
QuestionID (autonumber, primary key)
Question (text
tblANSWER
AnswerID (autonumber, primary key)
QuestionID (foreign key from tblQUESTION)
AnswerNo (Number - Long integer)
Answer (text)
Use a form based on tblQuestion and subform on tblAnswer
linked on QuestionID to enter your information.
Use a Query qryText drawing QuestionID and Question from
tblQuestion and AnswerNo and Answer from tblAnswer. The
next field is a calculated field,
MyRandom: Rnd([AnswerNo]). Sort on MyRandom.
For a quiz given on paper, use the Report wizard to build
a report on qryText. Group on QuestionID, then sort on
MyRandom. Make fields you don't want to see Visible=False
Roxie Aho
roxiea at usinternet.com
