Multiple Answers in a field?

  • Thread starter Thread starter Fiona
  • Start date Start date
F

Fiona

Hi,

I am very new to this so please excuse my ignorance. I am
setting up a database for survey results and many of the
questions have multiple answers, ie. 'check all the boxes
that apply'. I need to know how to set this up in the
table or tables. I itend to set up a form so that anyone
can input the answers and I would like to present
questions like these in a check box format. How can I do
this? I am using Access 2002. Appreciate any help.
Thanks.

Fiona.
 
Hi,

I am very new to this so please excuse my ignorance. I am
setting up a database for survey results and many of the
questions have multiple answers, ie. 'check all the boxes
that apply'. I need to know how to set this up in the
table or tables. I itend to set up a form so that anyone
can input the answers and I would like to present
questions like these in a check box format. How can I do
this? I am using Access 2002. Appreciate any help.
Thanks.
Click to expand...

You may want to check out Duane Hookum's "At Your Survey" sample
database, designed for exactly this purpose:

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'

The short answer is - you don't want to store multiple answers in a
field; instead, you would have a one-to-many relationship to a second
table, and store multiple records, one for each answer.
 
Back
Top