1. Run the Dropped Member Report to identify dropped members. On the General tab, select to create a constituent output query (Query A).
  2. Run the Lapsed Member Report to identify lapsed members. On the General tab, select to create a constituent output query (Query B).
  3. Create a constituent query (Query C) and filter on Membership, Current, Standing equals Active.
  4. Merge Query A and Query B using the OR operator creating Query D. The order of the queries does not matter.
  5. Merge Query C and Query D with Query D as the primary, Query C as the secondary, and SUB as the operator. This query pulls all constituents who are lapsed or dropped and do not have an active membership.