Quiz database, multiple random topics

[Sten]

Hi all,

I am working on a application to automatically generate quizzes. I have all of my data broken up into catergories, for instance:

Red
Blue
Green

Now I want to generate a test of 15 questions that take 5 random Red, 5 random Blue, and 5 Random green questions. My problem is I can get 5 random questions from any single catergory, but I can't figure out how to get them all. I thought about doing 3 different queries, and then a forth query that calls them all. Then I realized in the future I may add new catergories and would have to redo the query every time. I was thinking of a for each statement? Any ideas would be greatly appreciated.

Thank You,
Sten

 

[Fornatian]

I would start here to pull an x of questions per group.

http://support.microsoft.com/?kbid=210039

Now you know how to do this the next step is to randomise the data each time to ensure different questions are pulled through on each pass.