AnsweredAssumed Answered

Count of Occurrences of element in a field

Question asked by JamesSick on Jan 2, 2014
Latest reply on Jan 2, 2014 by JamesSick

Title

Count of Occurrences of element in a field

Post

     Hello everyone,

      

     I am trying to make reports of a student satisfaction survey to return to teachers. There are 25 courses, 14 questions, anywhere from 5 to 20 students per course. All questions were multiple choice, Strongly AgreeAgreeDisagree, or Strongly Disagree. I would like the teacher report to simply report the raw count of course takers who answered Strongly AgreeAgree, etc. for each question. Something like this:

      

     Course: American business

     Teacher: Mike

      

     1. The course goals were clearly presented:   (SA) 7    (A) 5    (D) 1  (SD) 0

     2. The course increased my understanding:    (SA) 7    (A) 5    (D) 1  (SD) 1

      

     I've set up two tables and joined them:

      

     Courses

       Course_ID

       Teacher

      

     Responses

       Course_ID

       Question_ID

       Response

      

     I've been unable to figure how to count the number of SA or A responses to each question for a Found Set (a course). Should I be using a Summary Field  = Count? This seems to count all fields with a response. That is, all of them. Is there a way to count if response = SA, as I would do in Excel? Do I have the database tables set up correctly? I'm I barking up the wrong tree? Any help or pointers greatly appreciated.

Outcomes