I am the Treasurer for a small church. I have been asked to create a database to track member attendance at different events such as (Sunday Worship, Bible Class, Communion, Etc.). I am using Access 2013. I have created 3 tables, they are Member, Event, and Events Tracker. Events Tracker has 3 fields: Member, Event, and Event Date. The Member and Event fields use drop down boxes from their perspective tables. I have created a report that is grouped on the Event Date. When I filter a specific event how can I have the Event Date column only a number that gives the total of specific dates rather than a count of all the records? Then how can I take the total of the records and divide by the number of distinct dates?
11/5/2023
11/10/2023
11/5/2023
11/15/2023
11/20/2023
11/5/2023
In this example there are 6 records with 4 distinct dates. The average is 1.5 (6/4 = 1.5).
Thank you for your help.
Ptla