Query to random select top N values

[Guest]

Hello Guru's....

I have a table called SubTopics with the following, (there are approximately
15 SubTopics)
Sub_Topic_ID
Sub_Topic_Description
Sub_Topic_Number_Of_Questions

Sample Data:
23,General Pharmacology,3
33,Autocoids,5
34,Toxicology,2

and.. a table called Questions with the following (There are approx
300questions)
Sub_Topic_ID
Question_ID
Question_Description
Question_Random_Number (using the rnd function)

I would like to create a query that selects only the number of questions
from the table "Questions" specified in the Sub Topic. ie if i have a
subtopic titled "General Pharmacology" and there are 14 questions, I randomly
want to select 3.

I hope that makes sense


Many many many many thanks

 

[Guest]

Hi Len
Thanks for the reply.

I'm pretty much a "cut & paste, nut-it-out" type of Gal and willing to give
it a go.

Any assistance greatly appreciated.

Many thanks