Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tally Survey Results

    Can you post the SQL from your query? That will help the Loungers troubleshoot your problem more efficiently.

    Thanks

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tally Survey Results

    Debi: In your QBE grid place the results field and do a 'Group By' on it. Place the results field in the QBE grid a 2nd time and do a 'count' on it. I think this will give you the desired results.

  3. #3
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tally Survey Results

    You may want to look into Cross Tab Queries in Access Help.

  4. #4
    debi_santini
    Guest

    Tally Survey Results - SOLVED!

    SOLVED - See end for solution.
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~
    Just found the lounge and would like some advice/input/answers!!! Let me apologize right now for any ignorance I display. I am new to Access but fairly adept at databases and reporting in general. However.....

    I need to tally survey results using Access. Created a table to hold the results from the 15 questions asked. Also created a great form for entering the results into the table and it works fine. We're asking the respondents to rate items on a scale from 1 to 5. So question 1 could have a value of 1 or 2 or 3 or 4 or 5. Same with questions 2 thru 15.

    Now I want to generate a query or report that will tell me for each question how many respondents answered 1, how many answered 2, how many answered 3, etc. Should be simple but I CANNOT MAKE IT WORK! Have tried COUNT[field] where = 1, have tried calculated text boxes, etc.

    Have been unable to find assistance with Access Help, Microsoft knowledge base, Geek Girls, or Woody's Access Watch Archives.

    Any advice or suggestions would be greatly appreciated. I am not opposed to redesigning the table if necessary. Only test data has been entered so starting over would not be the end of the world. Thanks in advance for any help! Have a great day.

    Am using Access 2000 with SR-1.


    <img src=/S/joy.gif border=0 alt=joy width=23 height=23>
    Eternal Thanks to all who responded. Found the solution in (of all places) the Microsoft Product Support Services Access 2000 'Find a solution' section. It did not come up just using an Access search - had to use the 2000.

    The Article ID is Q209505 and the title is "ACC2000: Expressions to Count Yes, No, and Other Responses".

    In summary, the article says to use a report footer with the expression =Sum(IIF([fieldname]=3,1,0)) {substituting 1 thru 5 in place of the 3} for each of the counts. Worked great. Silly me, I was trying to use COUNT to count something when I should have been using SUM! Go figure! <img src=/S/joy.gif border=0 alt=joy width=23 height=23>

Posting Permissions

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