Multiple Answers in a field?

[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.

 

[John Vinson]

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.

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.

 

[TC]

In addition to what John said, try the following article:

http://support.microsoft.com/support/kb/articles/Q100139.ASP

HTH,
TC