I have a question about some (for me) difficult calculation.
I have a table with Events. Every Event can have several participants (own table). The event has a limit of how many participants it can have. Every participant has a status, which can be "allowed" or "not allowed" (which is choosen from a valuelist). My question is, how can I count how many of the participants that have the status = "allowed"?
regards
/P