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

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.
Similar Threads
  1. Gene

    Hyperlink Answer

    Gene, Aug 1, 2003, in forum: Access Table Design
    Replies:
    1
    Views:
    87
    Allen Browne
    Aug 1, 2003
  2. Rick B

    Pictures and Records (repost - no answer yesterday)

    Rick B, May 21, 2004, in forum: Access Table Design
    Replies:
    2
    Views:
    105
    Roger C. Bledsoe
    May 28, 2004
  3. Michelle

    automatic answer based on other field/column entries?

    Michelle, Jun 3, 2004, in forum: Access Table Design
    Replies:
    2
    Views:
    118
    Lynn Trapp
    Jun 3, 2004
  4. garath

    creating an answer based number of records

    garath, Sep 27, 2004, in forum: Access Table Design
    Replies:
    1
    Views:
    99
    Eric Butts [MSFT]
    Sep 27, 2004
  5. DissentChick

    Easy Question, Can't see Answer

    DissentChick, Jun 10, 2005, in forum: Access Table Design
    Replies:
    4
    Views:
    107
    DissentChick
    Jun 13, 2005
  6. Phil D

    how to create a question answer form?

    Phil D, Nov 17, 2005, in forum: Access Table Design
    Replies:
    1
    Views:
    107
    Duane Hookom
    Nov 17, 2005
  7. Alec M1BNK
    Replies:
    1
    Views:
    121
    John Vinson
    Mar 2, 2006
  8. oldblindpew

    Question and Answer tables

    oldblindpew, Jan 20, 2010, in forum: Access Table Design
    Replies:
    3
    Views:
    96
    Duane Hookom
    Jan 21, 2010
Loading...