Survey Table Design

[JD McLeod]

I am creating a survey and need help with the table design. The survey will
consist of about 20 to 30 questions. Each question will have several options
for an answer, ranging from 2 to 5 options. Some questions will be Yes/No.
I would like to have the answers appear on the form as option buttons. I was
thinking about having one table for the questions and one for the answers.
Not all questions will have the same number of answer options and each
question may have a different type of answer (i.e., numbers, Yes/No,text)
Ultimately I would like to use option groups on my forms. Right now, I can
get this to work by using a list box for my answers, but can’t get it to work
using an option group. Any help would be appreciated.

 

[John Vinson]

I am creating a survey and need help with the table design. The survey will
consist of about 20 to 30 questions. Each question will have several options
for an answer, ranging from 2 to 5 options. Some questions will be Yes/No.
I would like to have the answers appear on the form as option buttons. I was
thinking about having one table for the questions and one for the answers.
Not all questions will have the same number of answer options and each
question may have a different type of answer (i.e., numbers, Yes/No,text)
Ultimately I would like to use option groups on my forms. Right now, I can
get this to work by using a list box for my answers, but can’t get it to work
using an option group. Any help would be appreciated.

Duane Hookum has an excellent survey database: see

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

and select the "At Your Survey" link.

John W. Vinson[MVP]