9 Replies Latest reply on Nov 29, 2013 12:58 PM by philmodjunk

    Count and sort specific values of 6 checkbox/radiobutton fields

    NikVar

      Title

      Count and sort specific values of 6 checkbox/radiobutton fields

      Post

           Hi there!

           I want some help to do this...

           I have a database of 1000 companies.

           I asked 6 different people to fill a questionnaire about those cpompanies, with 4 answers: "Yes", "No ", "Maybe", "Don't know"

           I have made 6 checkbox fields (one per person) and now I want to summarize their answers, to see how many "Yes", "No", "Maybe" and "Don't know" there are per comany. (I can also "convert" Checkbox to Radio Button fields)

           E.g.: The first company's answers are:  3 "Yes", 2 "No" and 1 "Maybe".  

           Now I want to count the ammount of "Yes" and sort those companies like this: First, the company with the bigger number of "Yes" etc...

           Thank you very much in advance!