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
Conditions
Related Articles
How to add, remove, or replace a column
How to add, edit, or remove a condition
Updated