Random questions from multiple tables

[CarolW]

Hello everybody,
I have been tasked to create a DBase which at the click of a command button will to all intents and purposes generate an examination paper...


At work we are currently using a series of 'Word Doc's'which are static in that we only have a specific set of examination papers numbered 1- 4 which are alternately used on a quarterly basis and as a consequence easily compromised.


I have currently have ten tables in total... named 'Subject1', 'Subject 2' etc etc. Each table varies in the amount of questions held within. 'Subject1' for instance might contain 20 whereas 'Subject3' may only have 5. What I would like to be able to do via an input form is to manually specify the amount of records I would like it to generate, per the questions in the table, in order to generate an exam paper.


The Search Forum has given me some help/guidance, however I am completely lost as to how to apply it to the instance of multiple tables.


Your advice and help would be extremely well appreciated.

P.S... If I have posed this question in the completely wrong forum then please accept my profound apogies!!!

Kind Regards


CarolW

Please View Attachment..........

 

[The_Doc_Man]

You can do this any number of ways.

First, normalize your tables to a single table that has a field "SUBJECT"

Next, perhaps you would do best to read up on the RND function and randomize the numbers.

Then put a SINGLE field in the table. Write a query that updates the field to a random number.

NOW select your criteria for inclusion. For instance, do you want 20 questions at total random or, say 10 from subject 1, 2 from subject 2, etc etc...

Then do a select query that gives you back the top N answers for each topic. Whne you have that list, you have your tests.

 

[CarolW]

You can do this any number of ways.

First, normalize your tables to a single table that has a field "SUBJECT"

Next, perhaps you would do best to read up on the RND function and randomize the numbers.

Then put a SINGLE field in the table. Write a query that updates the field to a random number.

NOW select your criteria for inclusion. For instance, do you want 20 questions at total random or, say 10 from subject 1, 2 from subject 2, etc etc...

Then do a select query that gives you back the top N answers for each topic. Whne you have that list, you have your tests.

Thank you The_Doc_Man,
Apologies for the delay in responding.
I will give it a go in the next few days and will get back to you to let you know how i got on?

Thank you for taking the time out to respond...

Your help is much appreciated.


Many thanks

CarolW

 

[The_Doc_Man]

Delays are inherent in the nature of this forum. I can only connect on a limited basis myself. Even if I don't respond right away, others might do so. I advise you to SEARCH this forum for "random" because many others have asked questions regarding random sampling of a table.