Purpose of This Query
This query will give you a 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 subquery).
The query conditions start with a subquery, what this subquery does is says "Show me all the families that don't have a pledge for a certain time frame" So this could be your 2017 fiscal year, so you are asking for all the families that haven't given during 2017. From there you are going to add conditions that will say, "Of those families who haven't given in 2017, show me the families who did give in 2016."