Having trouble creating Quick Charts
I am looking to make a few reports based on a Safety module we call Observation cards. It has about 38 fields for occurrences and is an unrelated table. What I am trying to do is have the chart look like what is pictured below. It will chart by job site how many counts of unsafe occurrences have been reported. The problem I am having is that I want it to chart ALL job sites and counts, but instead it is counting individual reports. The fields themselves are check box sets from a value list of Safe and Unsafe. How do I get it to count only Unsafe selections and total all 38 fields with Unsafe selections for each job site?