How to get Total Count of value from drop down box
I have a table Clients with field, ActiveChecked. I have the control style as a drop-down list with values, Active and Non Active. How do I create a field that calculates how many Active clients a trainer has?
Example 3 trainers:
Trainer A - 50 clients (30 Active)
Trainer B - 30 clients (10 Active)
Trainer C - 35 clients (12 Active)