Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    11

    Unanswered: Sum scores for answers on form

    I made a table with fields representing questions on a questionaire. The answers are the same for all questions --which i made combo boxes for pulling from another table where I put the answers and their corresponding scores:

    table1 ---all questions are comboboxes with source as table 2
    [q1]
    [q2]
    .
    [q27]

    table2 -has the answers and scores
    [answer]-Not sure, sure, somewhat sure, completely sure
    [score] -1, 2, 3, 4

    I made a form showing the all the answers, and now I want to sum all the questions together for a final score. How do I do this? Also, if I made a field on the form summing the scores, will i be able to query off it. I will want to get a query with everyone and their final score.

    Any help much appreciated.

  2. #2
    Join Date
    Jul 2004
    Location
    Inverurie
    Posts
    628
    creating a sum of all scores would be simple enough, but wouldn't you want to see more detailed information, i.e. see the overall response to each answer i.e

    q1 -

    Not Sure - x people
    Sure - x people
    Somewhat Sure - x people
    Completely sure - x poeple

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •