I’m trying to figure out how to get a count of two differen’t linked fields from an adjacent table.
For example. My running group has events that people attend. So I have a table with all of the running group members, then I have another table which details all the events, and who attended it. In the event table the members that attended can be in one of two records (lead, attendee) depending on their role for that event. So back in the group members table, I’m trying to get a count of all the events that individual attended, and of those how many times they were the leader.
The attendend count I figured out by following another post, but I can’t seem to figure out now how to count of tose evens, how many times they were the leader.