How to build a query reporting Lybunt/Sybunt results for specific funds
This query will give you Lybunt/Sybunt results for specific funds. There are four screen shots below to help you build this query: the first two are the columns, and the second two are the conditions (with the second picture of conditions being the sub-query).
The query conditions start with a sub-query, which says: "Show me all the families that don't have a pledge to a certain fund." For example, the sub-query could ask for all the families that haven't given to 2017's fund. Then the query could specify, "Of those families who didn't give to the 2017 Fund, who has given to the 2016 Fund?"
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