I have a table of people who completed volunteer applications and a table of various volunteer jobs and a many to many link to link the volunteers to the activities they actually performed. That is working fine. I want to find all the people on the table of people who completed a volunteer application who have never volunteered at all. Is there a way to do that?
Linda shared this idea · Jun 14, 2014
Comments
1 comment
Hello Linda,
Unless there is a field in the table that identifies whether or not the volunteer has completed an activity, you will need to use table relationships to get this figure. You can use the count() function to see how many child records (activities) that a volunteer has completed. Below is a great article on child functions for you to take a look at. Hope this helps!
http://help.trackvia.com/knowledgebase/articles/356703-child-functions
Derrick
Please sign in to leave a comment.