- Joined
- May 13, 2013
- Messages
- 1
- Reaction score
- 0
Allright here's my problem. I have A table with all of my test names and how many questions per test. I have a test bank of 3000 some-odd questions and answers. What I would like to do is have Access go through the list of questions and assign each test the requisite number of questions.
It seems to me that all I should need to do is have some sort of query that has a loop going that runs through the question table and assigns Test1 to 10 separate questions, then continues through Test2, etc. (If Test1 and Test2 are names linking back to my test names table)
How would I go about that?
It seems to me that all I should need to do is have some sort of query that has a loop going that runs through the question table and assigns Test1 to 10 separate questions, then continues through Test2, etc. (If Test1 and Test2 are names linking back to my test names table)
How would I go about that?