How to build a query to report all registered families per organization
Below is an image of a query that will return all registered families based on organization information. This will give the count of all registered families that are at the selected organization with Organization ID, Organization Name and City of the Organization.
As the example shows, you may rename the columns on the right-hand side in order for the results columns to read easier. To get the correct results, you will need to do a 'count' of the family DUID. If you do a 'Sum,' it will add together each family DUID; so do a 'Count' and not a 'Sum'.
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
How to write a query reporting family information for those registered to a specific organization and who want to receive mail
3767 Ranchero Drive, Suite 100 | Ann Arbor, MI 48108 | Toll Free 866.930.4774 | Fax 734.205.1011
Please sign in to leave a comment.