Working with question-answer pairs

Discussion in 'Access Table Design' started by sydneyej@gmail.com, Jan 23, 2013.

  1. Guest

    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 5by 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
     
    , Jan 23, 2013
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.