Hello,
I have 2 fields, 1 is a list of students names (field1), the other is the corresponding students class code (field2). Field 2 has data "R1-R7, B1-B7, A1-A7, M1-M7" I want to know how many students there is in each lettered group (A, M, B, R). I've used the 'count' total query however that only gives me the number of students in each individual class e.g. R1, B6, M3. I need a way to count the total of all the students in the 'R' group (R1-R7) and so on for the other 3.
Thanks,
Alex