Sorry, Naomi i have not understand.
My table name is dlyatten and filed name is Category and in Category i want to count the records if A,A,A is adjasent.
e.g
A is absent of student. ( it is dialy attend (roll call) from.
I want to see a student if he make six absences regulary.