What you have is known as 'repeating' fields and will usually raise issues of one kind or another. This is probably one of them. It mimics a spreadsheet, which is not conducive to databases. You should have something more along the lines of a field (e.g. ComType) with record values that are the PK values (usually autonumbers from tblCommitteeType) as the FK (foreign key) values for those records. If that all sounds like Greek to you, then you need to study db normalization before doing anything else. I can provide some links if you need them.
Once the schema is fixed, getting anyone's list/count of committees will be simple. Not only that, if you need to edit a committee name, your approach is more difficult and liable to failure. Also, adding a committee type will upset a lot of design.
Last edited by Micron; 11-22-2021 at 05:07 PM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.