info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Working with question-answer pairs
3 views
Skip to first unread message
sydn...@gmail.com
Jan 23, 2013, 5:38:03 PM1/23/13
to
Hello!
I'm looking for resources to help me turn my data, stored as question/answer pairs, into tables.
Right now I have three tables: answers (UID, questionID, answerID), forms (UID, submitter, submit_date), and masterAnswers (answerID, answerValue).
I can generate a query that will tell me all the responses for questionID 5 by UID. Or I can generate a query that will tell me all the UIDs associated with answerID 2. But what I need is to create a series of analytic tables (probably crosstabs), so I can get UIDs as rows, with questionID 1, questionID 2, etc. as columns, displaying the answerIDs as the values.
Are there any good tutorials, books, websites, etc. out there that can provide instruction? Or is Access the wrong tool for this job?
Thank you!
Sydney
I'm looking for resources to help me turn my data, stored as question/answer pairs, into tables.
Right now I have three tables: answers (UID, questionID, answerID), forms (UID, submitter, submit_date), and masterAnswers (answerID, answerValue).
I can generate a query that will tell me all the responses for questionID 5 by UID. Or I can generate a query that will tell me all the UIDs associated with answerID 2. But what I need is to create a series of analytic tables (probably crosstabs), so I can get UIDs as rows, with questionID 1, questionID 2, etc. as columns, displaying the answerIDs as the values.
Are there any good tutorials, books, websites, etc. out there that can provide instruction? Or is Access the wrong tool for this job?
Thank you!
Sydney
0 new messages