Select Equal type - Based On Random Query

[CarolW]

Good Afternoon Everybody,

Apologies for imposing on you all but I was wondering whether or not you could help me out??

Would you be so kind as to kind as to show me a practical example of how to incorporate a facility into my attached Database which serves to select an equal ratio of my field “SectionHeadings” such that out of the 30 “random” questions that it currently generates it will provides me on completion with the following:

5 From Set1
5 From Set2
5 From Set 3 …..etc etc

It currently generates the 30 questions that I need without a problem; however it routinely selects any number of one particular type, sometimes more from one subject and less of another.

All subjects headings are of equal importance to me and as a consequence would be very grateful if you could look at what I’ve already done and show me what needs to be done in order to achieve my aim.

I hope my request is possible - Any help you could give me would be very much appreciated. Thank you very much.

Best Regards

CarolW

 

[ejstefl]

My initial reaction is to write 5 queries, one for each set. The queries would choose 5 questions at random in that particular set.

Then, you could use a Union Query to bring the results together into one query.

I'm not sure if there is a better way than this or not...

 

[CarolW]

My initial reaction is to write 5 queries, one for each set. The queries would choose 5 questions at random in that particular set.

Then, you could use a Union Query to bring the results together into one query.

I'm not sure if there is a better way than this or not...

Good Morning ejstef,
Thank you very much for the quick response.
Could you or some other nice person, kindly show me how to do such a thing
via my attached Database. Im really not that knowledgeable but learn quickly when shown. The forums search facility have stacks of useful stuff on ' union queries', so much so that I get really confused.


Hope you can help further.............Best Regards

CarolW

 

[CarolW]

Good Afternoon Everybody,

Apologies for imposing on you all but I was wondering whether or not you could help me out??

Would you be so kind as to kind as to show me a practical example of how to incorporate a facility into my attached Database which serves to select an equal ratio of my field “SectionHeadings” such that out of the 30 “random” questions that it currently generates it will provides me on completion with the following:

5 From Set1
5 From Set2
5 From Set 3 …..etc etc

It currently generates the 30 questions that I need without a problem; however it routinely selects any number of one particular type, sometimes more from one subject and less of another.

All subjects headings are of equal importance to me and as a consequence would be very grateful if you could look at what I’ve already done and show me what needs to be done in order to achieve my aim.

I hope my request is possible - Any help you could give me would be very much appreciated. Thank you very much.

Best Regards

CarolW

Sorry for the above thread being re-posted but I thought i'd give it another go in the vain hope that some nice person might help me out of a sticky situation. ejstefl replied earlier but I am still none the wiser.

If somebody could take a lokk at my earlier attachment then I would be oh so grateful......

Kind Regards

CarolW

 

[ejstefl]

Here you go.

 

[CarolW]

Select Equal Type - Based On Random Query (Grateful Resolution)

Here you go.

ejstefl,

Perfect - Thank you ever so much...

Now that I have seen what you have done using my incomplete attachment I can now begin to recognise what is required, and the thought processes that actually occur behind the 'scenes'.


Extremely grateful for your help...


Regards

CarolW