AnsweredAssumed Answered

Counting Value List with Multiple Selections

Question asked by alinicjones on May 29, 2015
Latest reply on May 31, 2015 by erolst

I've read through number of discussion on this on the forum but still can't seem to get it to work properly. I have a database that audits research studies. I have a form where they select codes on the form where i have a value list check boxes of 43 different codes they can choose from. They might choose none or 10 options. I need to come up with a way to do a report that counts the number of times each of the individual codes have been chosen. I started the process with a very lengthy option that doesn't seem to work where i created a field for each code and used this formula: If ( RT_Code = "Assent"; "1" ; "" ). Then i did a count of each code. The numbers are not matching up. Any suggestions on a better way to do this? Any help would be greatly appreciated!!