Start your query:
  1. Navigate to Analysis, then click on Information Library
  2. Click Add an ad-hoc query
  3. Select source view of Revenue and click OK
Add fields to Include records where:
  1. In the left column, select Revenue Letters. From the middle column, drag Acknowledge date into Include records where. Set equal to Blank.
Add fields to Results fields to display:
  1. Amount and Date are added to Results fields to display by default with a Revenue source view
  2. To see Constituent name: In the left column, select Constituent. From the middle, drag Name into Results fields to display.
  3. To see revenue ID: In the left column, select Revenue. From the middle, drag Revenue ID 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

Here is an example of what your final query will look like:

User-added image