How to build a query reporting registered parishioners who have given to a specific fund on behalf of their parish
The purpose of this query is to help you get family information for parishioners who are registered to a parish and who have given on behalf of that organization. The query columns simply have the families' formal salutation and email address. You may add additional information in the Result Columns window.
You will notice in the query conditions that organization ID is present twice. The reason for this is that a family may be registered at a different parish but gave to the parish you are pulling information from. This brings us back to the purpose of this query, to 'get family information for parishioners who are registered to a parish and who have given on behalf of that organization.' Please see pictures below on how to build this query.
Results Columns 1
Results Columns 2
If you found this article helpful please give a thumbs up below and if you found that there are things missing please leave a comment so that we can update the article
3767 Ranchero Drive, Suite 100 | Ann Arbor, MI 48108 | Toll Free 866.930.4774 | Fax 734.205.1011