Rob, For a similar project using multiple choice, I set up the question table with the correct answer in a distinct field in that table. I also have a field for the 'type' of question (math, logic, general, etc.)
I simply write the answers to a table (tblAnswers) using the login as an identifier for the answers given by each individual. Then I query against tblQuestions to get each individual's answers and whether they were correct or not. I can also see how each person did in relation to all people that have taken the assessment, broken out by the question type. If you were to use 'Department' instead of 'type' you could achieve the same thing. HTH, Mark Rider -----Original Message----- From: lamb.rob [mailto:lamb.rob@;dbn.hc.co.za] Sent: Monday, November 04, 2002 2:16 AM To: ActiveServerPages Subject: Assesment site Hi Everyone I have a site where a client wants to do assesments... There are about 20 departments and each one has 10 questions. They want results added to a database. I have set up a deatabase with all thye questions and have a page that pulls the questions out depending on the department selected. I then have a repeat to construct the questionare. What I am wanting to know is..is it possible to save the results in a table so that you get a set of results that would save each question and answer into its own field in a table, or would I have to create a page for each department questionaire and save the results to the 'results' table from there. TIA Rob --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
