Values same table for 68 Q yes=+, No=-, U=0, 75 Q yes=-, no=+

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access - I am trying to set up one table that will store responses to 143
psychological questions where the responses are YES, NO and Unsure. 68 of
the questions have a postive value for YES, negative value for NO and 0 =
unsure, the remaining 75 questons have a negative value for YES, Positive
value for NO and 0=Unsure. How do I set up the Option Button for this type
of requirement? OR can I collect the data in one table. It has been a few
years since I've done anything with this program.
 
You have two issues.

First, the table: you can handle the values from a single field but
you'd need to have another field act as a flag indicate how to
interpret the values in the current record.. Not a good way to go.
You should settle on one set of values and then make both sets of
question return the same value for the same response.

Second, The Option group. You'd have three option buttons in your
Answer option group. You are able to set the value independently for
each of the buttons. option group will return the value of the
clicked button.

HTH
 
Back
Top