AnsweredAssumed Answered

Running count of students and grouping by grades

Question asked by ChristopherColes on Aug 27, 2018
Latest reply on Aug 27, 2018 by ChristopherColes

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

Outcomes