More than one answer to a question

[Ben McCall]

I am working on a questionnaire in Access 97. I have had no difficulty setting up questions with multiple choice answers where only one answer is wanted or fill the blank questions where the "responder" types in an answer.

I have been trying to set up a question were more than one answer may be correct but have had little success. I can find nothing in the help section or in the literature to help.

Can someone explain to me how to approach this problem?

Thanks!

Ben McCall

 

[Angello Pimental]

How exactly have you setup the questions and answers in your table?
Personally the way I would do it would be to assign a value for each answer. So that correct answers are a value of 1, wrong answers value of 0.
This would allow you to assign to answers a correct answer value, and give you the added feature of tallying up how many questions the user got right.

Well thats my two cents,
HTH
Angelo

 

[Ben McCall]

This is a medical history questionnaire. So ther are no correct or incorrect answers.

Ben

 

[sheederj]

there are a few ways that you can solve this...
The easy, sort of cheating way is:

What are your favorite letters?
choices are:
a
b
c
d
On the form, have the person enter a d
for example, then when you want to access that data later in a query and you want to see all the people who responded d you would have is search any part of the field. this will only work with unique selections (1 12 would not work because 1 is in 1 and 12).
The other way is to put that question into it's own table and make a subform on your form. For example, I have a parent table that is patients, each patient can have multiple diagnoses (one to many relationship) on the form, the nurse will enter each diagnosis code for that patient in a subform.
It really just depends on how complex your question is, I use both methods in my current database and it works fine, the key is how you need to display and retrieve the data later. Hope that helps.
-Jeanelle

 

[sheederj]

I thought I better add, your new table might be:
patientid diagnosiscode

make both fields primary keys so that each record is unique and link to your main table by patientid.
-Jeanelle