I have an AfterCare db that when you check a student into the db it creates a date/time record for that student and sets a Check In Status field to 1 until that student is checked out then that status field is set to 0.
In my main layouts I have a field that shows a running count of how many students are checked into AfterCare and it increases and decreases accordingly.
Our school goes from PreK 3 through the 8th grade which I set as grades -2 through 8 in the database.
Is there an easy way to get running counts of grades -2, -1 and running counts of 0, 1, 2, 3, 4, 5, 6, 7, 8 separately?
Many thanks in advance.
I have the grade number on the same layout as the Check In Status