I have a table (tbl_Charges) which lists by individual a main charge classification and within the main class, it lists up to 5 infraction classifications. These are in text form. I need to be able to total the infractions by their classification.
1st_Class 2nd_Class 3rd_Class 4th_Class 5th_Class
Safety Safety Conduct Performance Conduct
Performance Conduct Safety
Report to show:
I just can not wrap my head around it.