By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,805 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

Help needed to store quiz solutions from db to VB

P: n/a
Basically I want to store the answer of a single-choice question
(where candidate selects one answer) and multiple-choice question
(where candidate selects more than one answer). I would like to store
it in a table and then when I run the quiz application on VB, I would
like to track answers for both types of questions.

Please help me solve this problem.
Much appreciated.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
ka******@hotmail.com (Mohammed Mazid) wrote in message news:<7c**************************@posting.google. com>...
Basically I want to store the answer of a single-choice question
(where candidate selects one answer) and multiple-choice question
(where candidate selects more than one answer). I would like to store
it in a table and then when I run the quiz application on VB, I would
like to track answers for both types of questions.

Please help me solve this problem.
Much appreciated.


I have created a similar database before. You can create a table that
will list the questions and say what type each question is. It would
either be a single-choice question or a multiple-choice question.
Create a combo table to store the answers to the questions. There
would be an id field, a question number field and a question answer
field. For the single question an example would be
id=1,Quest=1,Answer=a. For a multiple question an example would be
id=2,Quest=2, Answer=a and id=3, Quest=2, Answer=b.
Hope that helps. If interested I could maybe help create a database
for you.

www.klh-tech.com
KLH Technology Solutions
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.