R
ROC
I have an Access 2007 project that requires the user to respond to a
group of questions. The results of those responses are then stored
with other responses and then compared with one another. The
questions table includes a list of column qualifiers and both the
questions and qualifiers change over time. I want to store the
responses in a different table by adding the participants response as
a new column using an autoid field as the link. Makes sense? What is
the best way to approach this problem? I am not a programmer. I just
use the mechanical controls of Access.
Table
Id Question code1 code2 code3 code4
1 How many widgets n y y
y
2 How big box x
3 Size of circle x y
New Table
Qualifier = code3 Participant Id
Id Question Mary John
1 How many widgets x x
2 How big box
3 size of circle x x
group of questions. The results of those responses are then stored
with other responses and then compared with one another. The
questions table includes a list of column qualifiers and both the
questions and qualifiers change over time. I want to store the
responses in a different table by adding the participants response as
a new column using an autoid field as the link. Makes sense? What is
the best way to approach this problem? I am not a programmer. I just
use the mechanical controls of Access.
Table
Id Question code1 code2 code3 code4
1 How many widgets n y y
y
2 How big box x
3 Size of circle x y
New Table
Qualifier = code3 Participant Id
Id Question Mary John
1 How many widgets x x
2 How big box
3 size of circle x x