How to Count Check Boxes that are checked Yes in an Access 2003 Report
Posted on 2008-11-03
I have a table that has 10 different check boxes for various options. I need to create a report that shows the total number of times each check box is selected. Some records can have multiple check boxes selected and other records might not have any check boxes selected.
(Examples of field names for the check boxes are, patient_reffer_family, patient_reffer_insurance, patient_reffer_friend)
I also want to show a total number of records that have at least one of the available check boxes selected. I want to use that number to figure out percentages based on the totals from the individual check box totals.
I beleive I need to use the count feature, but I am not sure how to code this properly If possible, examples of how to use this code would very helpful.