Start your query:
  1. Navigate to Analysis, then click on Information Library 
  2. Click to Add a new Ad-hoc query 
  3. Select the source view of Constituents and click OK
Add fields to Include records where:
  1. To remove Inactive records: In the left column, select Constituents. From the middle column, bring Is inactive into Include records where. Set Equal to No.
  2. To remove Deceased records: From the same middle column, drag Is Deceased into Include records where. Set Equal to No.
  3. (Optional) To only see only Individuals, not Organizations: From the middle column, drag Is individual into Include records where. Set Equal to Yes.
Add fields to Results fields to display:
  1. By Default, Name is included within your Results fields to display.
  2. To see Constituent Lookup ID: In the left column, select Constituent. From the middle column, bring Lookup ID into Results fields to display.
  3. To see Primary Address: In the left column, select Address (Primary). From the middle column, bring Address line 1 into Results fields to display. From the middle column, continue this for City, State and ZIP.
    • Note: If you also want to include the primary phone number or email address for these constituents, you will follow the additional steps detailed here.
Save your query:
  1. Click the Set save options tab
  2. Name your query
  3. Save and Close