Store Survey Responses

[ROC]

I have created a survey with multiple questions by several categories.
Survey answers are stored in an answer file using a unique identity. The
trouble is that I use too many rows for each participant. I would like to
store the responses in a single row. Is there some way to transpose (like
excel) the multi-row response into a single row for storage and comparison
and then pull that response back into a table for viewing?

question 1 (q1)
question 2
question 3 becomes

q1 q2 q3

Or is there a better way to address this problem?

Thanks.

 

[Rick Brandt]

I have created a survey with multiple questions by several categories.
Survey answers are stored in an answer file using a unique identity.
The trouble is that I use too many rows for each participant. I would
like to store the responses in a single row. Is there some way to
transpose (like excel) the multi-row response into a single row for
storage and comparison and then pull that response back into a table for
viewing?

question 1 (q1)
question 2
question 3 becomes

q1 q2 q3

Or is there a better way to address this problem?

Thanks.

The way you are doing it now is correct. The way you *want* to do it is
wrong. What does "too many rows" mean. You have as many rows as you
have answers to questions right? That would be the exact amount you
should have.

 

[ROC]

Rick,

If there are 5 participants taking a survey with 10 questions, then I am
storing 50 rows of data. For storage purposes and numerical analysis I would
like to store the responses in a single row. I would then use that row to
extract my responses when needed. In testing alternatives I have set up my
question table using an auto ID field. I have then collected one paticipants
responses and transferred them to an Excel spreadsheet. I then transposed
the spreadsheet and linked those results to an Access spreadsheet. Any
update to the Excel file then auto updates in the Access file. Rows in the
Access file match the sequence of numbers in the auto ID questions.
Unfortunately, I have to use several text rows and am not able to do this
using this methodology. I am looking for a solution that will allow me to
create and extract the answer file more effectively.