E
E.Q.
We have a database to track training. One table, tblQuestions, contains
questions to test employee knowledge at the end of training. So far we have
327 questions in that table.
We'd like to tag a few questions that will appear on every test and randomly
select about 30 more for a 50-question test.
I've added a boolean field to the table to tag the "Universal" questions. I
have two queries that work properly. Each outputs a two-field dataset
(lngSkillSetID and chrQuestion). qryUniversal selects questions for which the
boolean is true; the other, qryRandomQuestions, uses "top 30" with the
random feature.
I can fudge the 50-question test by creating a blank table and doing append
queries on that table using qryUniversal and qryRandomQuestions.
I would like to have a single query to combine the output from
qryRandomQuestions and qryUniversal and use a report to generate the test.
Would this be a case for the "Make Table" query option? What would be the
best way to set this up so my fellow supervisors that are less
Access-litterate can create a test?
Any help will be appreciated.
Peace.
EQC
questions to test employee knowledge at the end of training. So far we have
327 questions in that table.
We'd like to tag a few questions that will appear on every test and randomly
select about 30 more for a 50-question test.
I've added a boolean field to the table to tag the "Universal" questions. I
have two queries that work properly. Each outputs a two-field dataset
(lngSkillSetID and chrQuestion). qryUniversal selects questions for which the
boolean is true; the other, qryRandomQuestions, uses "top 30" with the
random feature.
I can fudge the 50-question test by creating a blank table and doing append
queries on that table using qryUniversal and qryRandomQuestions.
I would like to have a single query to combine the output from
qryRandomQuestions and qryUniversal and use a report to generate the test.
Would this be a case for the "Make Table" query option? What would be the
best way to set this up so my fellow supervisors that are less
Access-litterate can create a test?
Any help will be appreciated.
Peace.
EQC