How to build a query to report LYBUNT/SYBUNT results for a specific date range
This query will give you LYBUNT/SYBUNT results for a specific date range. There are four pictures 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. The sub-query says "Show me all the families that don't have a pledge for a certain time frame." For example, the sub-query could ask for all the families that haven't given during 2017. The query then could have conditions that would say, "Of those families who haven't given in 2017, show me the families who did give in 2016."
Columns #1
Columns #2
Conditions
Sub-query
Related Articles
How to add, remove, or replace a column
How to add, edit, or remove a condition
How to build a query reporting LYBUNT/SYBUNT results for specific funds
How to build sub-queries in IQ
Updated