hockey8837
Registered User.
- Local time
- Today, 00:59
- Joined
- Sep 16, 2009
- Messages
- 106
Hello,
I'm trying to get a report to give me a total count of volunteers for the year. I have an overall count, because for each event I enter the total bodies that were there. My problem starts when I try to count individuals.
My DB is designed so that I can look at a contact and see all events they've attended, or, look at an event and see all contacts who attended. I don't always get every person who was at the event to sign in (especially if they're children), but I do get a final head count and record that #. Additionally, I may have repeat volunteers, who come to more than one event over the year.
So, now I want to get an idea of how many individuals I had over the year. I know it will still be a rough #, since some events with schools had over 100 people, but I only have the names of the handful of teachers actually entered into the DB. I think it will come down to something like:
So, how do I get this into a query or, better, a report?
I'm trying to get a report to give me a total count of volunteers for the year. I have an overall count, because for each event I enter the total bodies that were there. My problem starts when I try to count individuals.
My DB is designed so that I can look at a contact and see all events they've attended, or, look at an event and see all contacts who attended. I don't always get every person who was at the event to sign in (especially if they're children), but I do get a final head count and record that #. Additionally, I may have repeat volunteers, who come to more than one event over the year.
So, now I want to get an idea of how many individuals I had over the year. I know it will still be a rough #, since some events with schools had over 100 people, but I only have the names of the handful of teachers actually entered into the DB. I think it will come down to something like:
Code:
(Volunteer Number for all events-Total ContactID)+(Unique Contact IDs for the year to eliminate repeat volunteers)
So, how do I get this into a query or, better, a report?