Need help on creating a type of Report

[Accessorize]

I'm using the database that was uploaded by a generous Utteraccess member (which is attached). it does everything I want it to do, except one thing. I was wondering if someone can help me modify this database so that when I print a test, it randomizes the questions from ONE test, dont care which one, and has them numbered sequentially.

In other words, I want to take one of the three mock tests and add 2200 more questions with four possible answers and then be able to generate a report that has 100 randomized questions PULLED from the 2200 questions. In a separate report, I want to be able to print out the answer sheet to those 100 chosen randomized questions sequentially.

In the future I want to be able to print out 100 random questions with a separate answer key to those randomized questions that are DIFFERENT from the 100 from before...I know this might sound strange, but I can explain in more detail if this isnt enough.

Thanks for the help, whatever kind I can get!



-Accessorize
USS George H W Bush

[weekend00]

1 I would prefer to combine table tblQuestions and tblchoices into one table.
2 Remove IntQuizID from tblQuestions. create another table to hold all quiz or modify tblQuizzes to hold all quiz
3 add 3 fields to tblAnswers: QuizID, QuestionID and Choice.

Then it will be easier to continue your work.