get random record in form

[Boss]

I have prepared a online test portal in MS access for 25 users.

Users login & they give test. All of them access same question master and
receive questions in their respective forms.

What i wish to do is i wish that every body gets records in random manner.

Idea is every body needs to solve ten questions from the question master but
the sequence should be different for all.

Can we do it using query or we need to write some macro..

Hope the problem is clear..
Kinldy help.. thanks a lot..

Boss

 

[Stefan Hoffmann]

hi,

What i wish to do is i wish that every body gets records in random manner.

Add a column RandomOrder: Rnd([yourAutonIncField] and sort your query
with that field.


mfG
--> stefan <--

 

[A Paid Observer]

Boss,
For what it's worth, I made up a test for my users that is probably similar
to what you are trying to do. I am very much an amateur at this kind of
thing, and there are probably several bugs in my programming that are just
waiting to pop up, but it works for now.
The format for my test was sort of easy, because it is multiple-choice.
Depending on what kind of test yours is, it is possible. Here's a brief
summary of what I did for a multiple-choice quiz:

- I have one table (tblAnswers) that contains just the four possible answers
to each question. Each answer has a number assigned to it from 1 to 4.
- Another table (tblQuestions) contains all 170 questions that I want to
select from. Each record in the Questions table has fields for the question,
correct answer, the answer given by the test-taker (left blank,) and a
primary key.
- A query randomly shuffles the records in the Questions table, and inserts
the top 50 records into a new table (tblTest1.) This new table becomes the
record source for each user's test. It also has fields for the date and
CurrentUser.
- The test form (frmQuiz) lets the user enter their answers with option
buttons. At the end of the test, a query calculates their score and saves the
score to a new table (tblTestResults.) A results form shows the user their
score, and the specific questions they answered incorrectly.
- Each time a user begins a new test, the old questions in the test table
are deleted, and the new questions are inserted.

Like I said, it works, although I'm sure it could be more efficient. Let me
know if I can help.