I have a table with contact information for several people. They have a column which states whether they are a chairperson or a rep.
I have 2 queries set up. One listing the chairs and another listing the reps.
I also have a table for meetings. In each meeting there is a chair and a rep. These are selected from a drop down in a combo box based on the 2 queries.
What I would like is an extra column in chair/rep queries which will tell me how many meetings they've attended.
I can't seem to get it working with the Totals function. Is there another way?