questions database and randomizing questions

J

Jeramie.proctor

I have currently added about 2000 multiple choice questions ( and a few True
false ) to my database. collum 1 has the question number in it then in the
second collum i have the question written out and then right below it in the
next few rows it has the answer options. I want to run a querey on this and
randomly pull say 25 or 50 questions w/ answer options. I was able to get
the answers and questions to querey over in order by adding a 3rd collum in
which i labeled all the questions and answers with the same number so when i
run a basic querey it does pull the questions to it but again it pulls all
of them to it ... PLEASE HELP....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top