1. Create a new student query

     
  2. On the Criteria tab, expand Student, Student Progression

     
  3. Select Academic Year with an Operator of Equals and enter the appropriate school year

     
  4. Select School with an Operator of Equals and enter the appropriate school

     
  5. Place  ( )  around these selections:
    1. Select the Academic year criteria and click the ( button at the bottom of the query screen
       
    2. Select the School criteria and click the ) button at the bottom of the query screen
       

     
  6. Expand Student, Status Log

     
  7. Select Status with an Operator of Equals and enter Current Student status
     
  8. Select Status Date with an Operator of Less than and enter the last day of the school year, or when you would no longer consider the student enrolled for that year

     
  9. Place  ( )  around these selections:
    1. Select the Current Student criteria and click the ( button at the bottom of the query screen
       
    2. Select the Status Date criteria and click the ) button at the bottom of the query screen
       

     
  10. Make sure the operator between the two sets is AND

    The criteria should now look similar to:

    criteria


     
  11. Select the Output tab, select the Full Name and any other fields to include in the results
     
  12. On the Sort tab, specify how the records should be sorted
     
  13. Select the Results tab to view the results of the query
     
  14. Save the query