Results 1 to 2 of 2
  1. #1
    tenn_tazz26 is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2020
    Posts
    1

    Survey report to count responses to each question

    I have a basic survey form where a user selects a company name and then answers 10 questions with a 1 to 5 rating scale for the answer to each question.



    I am trying to create a report that will list the provider on a page and then below it, going down on the left side is each question and then out to the right side of the question are fields for how many responses answered 1, how many chose 2, how many chose 3, and so forth. I cant seem to figure this out. Thus it may look something like this (i hope it formats properly for this forum)

    Scale rating 1 2 3 4 5
    ------------------------------------------------------
    PROVIDER1 3 2 5 7 8
    PROVIDER2 1 1 3 4 4

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,399
    look at using a crosstab query. Without knowing your table design, can't be more specific than that

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Placing responses to parameters on report
    By Varda in forum Reports
    Replies: 3
    Last Post: 08-12-2015, 01:36 PM
  2. Parameter Query/Report Question to Count Text
    By Lettyg82 in forum Reports
    Replies: 6
    Last Post: 08-13-2012, 03:47 PM
  3. Count responses based on entires of other table
    By VictoriaAlbert in forum Queries
    Replies: 2
    Last Post: 10-18-2011, 11:06 PM
  4. Count and crieria on Report question
    By AndycompanyZ in forum Reports
    Replies: 7
    Last Post: 08-10-2011, 06:54 AM
  5. Report from survey responses
    By Saramj in forum Reports
    Replies: 0
    Last Post: 02-20-2011, 04:59 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums