For each record in my table (tblStaff) there are 10 fields (Grade1, Grade2, Grade3...). I want to count the number of times specific criteria appears in these fields.
This table is linked to another table (tblGeneral) with city and state information. The tables are linked together with ChartID.
I am attaching my code, sample database and a document showing how I want the results displayed. The yellow highlights are the counts I am trying to get.