My school has historically used the letter 'q' when filling in registers to denote pupils that are in school but doing alternate activities (music lessons, mentoring, etc). I have been asked by our new attendance officer if it is possible to track the number of letter q's that are entered for each class since the start of the year.

In the past when Iíve been asked to track attendance by codes Iíve simply used the 'group analysis by code' report, however this only displays the approved codes for entering in registers, thus not the q's.

Any help would be greatly appreciated.