Lapsed donors

Steve Schapiro

I want to pull a report of people that have given in 2017 but not in 2018 within a certain dollar amount. What would be the correct report to run and with what criteria? 

Michael Langley 2

I would start with a query using Last Gift date 1/1/17 - 12/31/17 and gift amount between $ - $$ depending on your gift amounts.

Cammi Derr

Use a merge to pull 2 queries together with the "SUB" operator

Query 1: Year 2017 & giving amount criteria

Query 2: Year 2018 & giving amount criteria