I originally posted this incorrectly under Forms, so I am repeating it here.
I have master tables: Members Table, and Events table, and an Activities child table associating Event participation by Members. From the Events perspective, I can see all who participated in that event, and from the Members perspective, I can see all events each member participated in.
The Activities child table contains, among other data, the Event Type and the Member names, along with the linking pointers to the parent Event and Members tables records. I need to count the total of each event type and total of each type which each of the members participated in. Then I need to display those totals and calculate the percentage participation for each event type for each member. I expect I can do this by counting the events of each type in the Events table and the Activities child table. I am sure it is not all that hard, but being somewhat awkward at this, I am struggling to see just how to do this in a report, to produce stats for each of multiple event types.
Any suggestions how best to do this?