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!!