How to query on consecutive years given for constituents who started giving consecutively as of a specific date
1. Create a constituent query 2. On the Criteria tab, filter on Gifts, Gift date between [date 1] and [date 2] 3. Create several other separate queries, for any other date ranges that we are wanting to compare 4. Merge each query using the AND operator 5. Once the final merged query has been created, create a new constituent query 6. Set the criteria as: Gifts, Gift date not between [the date range prior to the first year you want to query on] 7. Merge the original merged query, with this other query. The original query is the primary, the new query is the secondary, and we use the SUB operator.