AnsweredAssumed Answered

Need help with counting field name

Question asked by danlee on Apr 19, 2015
Latest reply on Apr 24, 2015 by danlee


Need help with counting field name


I have Table Trainers, Table Active and Table Clients.  Relationship is from Table Trainers (_pkTrainerID) and Table Active (_pkClientStatusID)  to Table Clients (_pkClientStatusID & _pkTrainerID).  Table Active has field name, ClientStatus (Active & Non Active)

I would like to know how many Client Status Active are for each trainer.  So for example it should show me the active clients in my layout for each trainer like so:

TrainerA - 30 Active

TrainerB - 15 Active

TrainerC - 22 Active