1. Create a membership query.
  2. On the Criteria tab, select:
    History, Summary Information for All Memberships, Total Lapsed/Dropped Memberships greater than or equal to 1
    AND Current, Standing equals Active


To query on active members who previously were lapsed:

  1. Run the Lapsed Member Report.
  2. On the General tab, specify the most recent date the members could have a Lapsed status.
  3. Mark the Create output query checkbox.
  4. Click Print or Preview to run the report.
  5. On the Save Static Query screen, enter a query name and click Save.
  6. Close the report.
  7. Run the Renewal Report.
  8. On the General tab, click Include, Selected Records and searched for and select the output query created from the Lapsed Member Report.
  9. Select the date range during which the members should have renewed.
  10. Mark the Create output query checkbox.
  11. Click Print or Preview to run the report.
  12. On the Save Static Query screen, enter a query name and click Save. This query contains constituents who lapsed during a specific date range and renewed in another date range.