1. In Query, select New
  2. Select Student for Query type and Dynamic for Query format. 
  3. On the Criteria tab, select fields that will include all students you want to consider for hold codes.  For example, you may filter on Current
  4. Save and close this query - This will be referred to as Query 1 in later steps.
  5. In Query, select New
  6. Select Student for Query type and Dynamic for Query format. 
  7. On the Criteria tab, select the following fields, operators, and values:

    Student, Hold code status log, Hold Code Equals [select code] 
      -- You can use 'One of' for the Operator instead of 'Equals' if you have multiple Hold codes to include

    AND Student, Hold code status log, End Date Not Blank
      -- You can use 'greater than or equal to' for the operator instead of 'Not Blank' if you enter future dates and only want those that have not yet ended
     
  8. Save and close this query - This will be referred to as Query 2 in later steps.
  9. From the main query screen, select File, Merge
  10. Select Query 1 and Query 2 in the corresponding fields
  11. Mark the button for Select records included in Query 1, but exclude records included in both queries.
  12. Select Merge Now
  13. On the Output tab, select the fields of information that you want to see about the students.  For example, from under Student, Bio 1, select Last name and First name.
  14. Select the desired sort fields on the Sort tab
  15. Select Run and follow the prompts to save the merged, static query
The Results tab will show the list of students that meet your criteria.