1. Click Analysis > Click Information Library
  2. Search for Constituents with Consecutive Giving Years
Note: The query may also be named Constituents with Consecutive Giving Years - System Default. 
  1. Click the arrow beside the query name > Click Edit
  2. Make sure all of the following are specified for each section below: 
    1. Include Records Where: 
      • User-added image
      • In the left column, expand Smart Fields, then select Consecutive Giving Years Smart Field. From the middle column, drag Value into Include records where. Change the dropdown to Greater than and enter 0. Click OK.
    2. Results fields to display: 
      • ​​User-added image
      • To add Name: From the left column, select Constituents. From the middle column, drag Name into Results fields to display.
      • To add Lookup ID: From the left column, select Constituents. From the middle column, drag Lookup ID into Results fields to display.
      • To add Consecutive Giving Years Smart Field\Value: From the left column, expand Smart Fields, then select Consecutive Giving Years Smart Field. From the middle column, drag Value into Results fields to display.