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

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

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

Ben

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

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