Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Aug 2002
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Compiling Results (2002)

    Helloooo,

    I have a form that gathers information from our customers online. The questions are answered with "Satisfied", "Not Satisfied" or "N/A" in a drop down box. I need to run a report that lists each question, tallys how many answered "Satisfied" how many answered "Not Satisfied" and how many answered "N/A" for each question and then sates the percentage of each. Can anyone help me, I am sure this has been done before ? Any help appreciated [img]/forums/images/smilies/smile.gif[/img]

    Thanks,
    K

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Compiling Results (2002)

    What you want should be fairly easy, but it depends on the way you have organized your tables. I suppose you have a table with a unique question ID or question number, together with the question text, and another table with Customer ID, question ID and response. Is that correct, or have you designed another layout? And is the response stored as text ("Satisfied") or as a code (e.g. 1 = "Satisfied", etc.)? If you provide some detail, I'm sure someone will be able to help you.

  3. #3
    Lounger
    Join Date
    Aug 2002
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compiling Results (2002)

    I have two tables. One houses the data/results of the questionaire and the other the three answers for a lookup in the main table. It is fairly simple. The "Results" db has a column for each question, the column name being the question itself and a drop down box that looks up from the "Answers" table which has "Satisfied", "Not Satisfied" and "N/A". Any help appeciated. I believe it to be simple but am having a hard time getting a grip on it.

    Regards,
    K

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Compiling Results (2002)

    Thanks for the information. Your setup is not ideal. It means that you'll have to create the report by hand, and it'll be a lot of work, but it can be done.

    For demonstration purposes, I will assume that you have named the fields in your Results table Q1, Q2, ... Replace this by the names you actually used.

    (1) Create an unbound report (no record source)
    (2) Put a text box on it with control source =DCount("*", "Results") and name it txtNumberOfRecords.
    (3) Put a second text box on it with control source =DCount("*", "Results", "[Q1]='Satisfied') and name it txtQ1_Satisfied.
    (4) Put a third text box on it with control source =[txtQ1_Satisfied]/[txtNumberOfRecords] and set the Format property to percentage.
    (5) Modify the labels for the text boxes to something meaningful.

    We're not finished yet by a long way, but save your report now and open it in preview mode. You should see the number of people who have replied (the number of records), the number who replied "Satisfied" to Q1, and the percentage this is of the total.

    Switch to design view. Repeat steps (3) (4) and (5) for Q1, but with the other two possible replies.
    Now, arrange the text boxes in a way that pleases you. Save, and switch to preview mode to see the effect. You should see a summary for Q1.

    You will have to repeat this for Q2. You can do this by selecting the text boxes relating to Q1 (not the txtNumberOfRecords box), and clicking the Duplicate button. Then, you will have to change Q1 to Q2 in the control source, and set the Name property (the duplicates were assigned generic names like Text37).

    And then the same all over again for the other questions.

  5. #5
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Compiling Results (2002)

    You can do what Hans suggests which as Hans has said will take a lot of work.

    You might want to consider making up a number of append queries (same number as the number of questions) that append each question and answer to a new table. This table should contain an ID (autonumber), Question and Answer fields.
    Then as Hans was alluding to in his first reponse it is then a simple matter of getting the report you want.

    BTW, if I were you, next time I would design the form that has a row per question, then you can show the form in "continuous forms" view, and you can have as many questions as you like for very little extra effort.

    HTH
    Pat <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

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