Method 1
First, we'll create a query to find all donations
  1. Click Queries
  2. Click Manage Queries
  3. Select the category where you would like to store this query
  4. Select New Query under the Tasks menu
  5. Name the query All Donations
  6. Set the Starting Query to Base/All Constituents
  7. Set the Data Return Type to Journal Entries
  8. Under Criteria Matching select Match Each Criteria
  9. Select Commonly Used Fields from the Browse Fields drop down menu and click on Individual Transaction Received
  10. Fill in Greater Than or Equal to .01
  11. Click Save and View Queries

Then, we'll create a query to find the last donations
  1. Select New Query under the Tasks menu
  2. Name the query Last Donations
  3. Set the Starting Query to the All Donations query that we created above
  4. Set the Data Return Type to Journal Entries
  5. Under Criteria Matching select Match Each Criteria
  6. Select Journal from the Browse Fields drop down menu and click on First/Last Entry
  7. Select Last from the drop down menu and fill in 1 in the text box
  8. Click Save and View Queries
Last, we'll create a query to further define the criteria and look for last donations in a specific time frame
  1. Select New Query under the Tasks menu
  2. Name the query Last Donations from [insert dates]
  3. Set the Starting Query to the Last Donations query that we created above
  4. Set the Data Return Type to Journal Entries
  5. Under Criteria Matching select Match Each Criteria
  6. Select Commonly Used Fields from the Browse Fields drop down menu and click on Journal Entry Date
  7. Fill in the date range that you'd like to search
  8. Click Save and Preview
Method 2- for this example, we'll look for donors whose last gift was in 2015
First, we'll create a query to find everyone who gave in the time frame we'd like to search for last gifts (for this example, we'll search for gifts in 2015)
  1. Click Queries
  2. Click Manage Queries
  3. Select the category where you would like to store this query
  4. Select New Query under the Tasks menu
  5. Name the query 2015 Gifts
  6. Set the Starting Query to Base/All Constituents
  7. Set the Data Return Type to Journal Entries
  8. Under Criteria Matching select Match Each Criteria
  9. Select Commonly Used Fields from the Browse Fields drop down menu and click on Journal Entry Date
  10. Fill in the date range (for this example, we'll fill in 1/1/15-12/31/15)
  11. Select Commonly Used Fields from the Browse Fields drop down menu and click on Individual Transaction Received
  12. Fill in Greater Than or Equal to .01
  13. Click Save and View Queries
Then, we'll create a query to find everyone who gave after the specified date range (for this example, we'll look for gifts from 1/1/16 and after)
  1. Select New Query under the Tasks menu
  2. Name the query Gifts After 2015
  3. Set the Starting Query to Base/All Constituents
  4. Set the Data Return Type to Accounts
  5. Under Criteria Matching select Match Each Criteria
  6. Select Commonly Used Fields from the Browse Fields drop down menu and click on Journal Entry Date
  7. Fill in the Start Date as one day after the End Date in your previous query (for this example, our Start Date will be 1/1/16); leave the End Date blank
  8. Select Commonly Used Fields from the Browse Fields drop down menu and click on Individual Transaction Received
  9. Fill in Greater Than or Equal to .01
  10. Click Save and View Queries
Last, we'll create a compound query to build our final list
  1. Select New Compound Query under the tasks menu
  2. Name the query Last Donations from [insert dates]
  3. Set the Data Return Type to Journal Entries
  4. Under Combine the Queries select Subtract
  5. For Query 1 choose the first query we created; in this example, Query 1 will be the 2015 Gifts query
  6. For Query 2 choose the second query we created; in this example, Query 2 will be the Gifts After 2015 query
  7. Click Save and Preview