Start your query:
  1. Navigate to Analysis, then click on Information Library
  2. Click Add an ad-hoc query
  3. Select source view of Memberships and click OK

Add fields to Include records where:
  1. In the left column, select Memberships. From the middle column, drag Status into Include records where. Set Equal to Lapsed.

Add fields to Results fields to display:
  1. In the left column, expand Member and select Constituent. From the middle column, drag Name into Results fields to display.
  2. To see expiration date: From the middle column, drag Expiration date into Results fields to display.

Save your query:
  1. Click Set save options tab
  2. Name query
  3. If you will be using this query elsewhere in Altru, mark to Create a selection
  4. If you will be using this query in another query, mark to Show this Selection in the Query Designer
  5. Save and Close