• On the Criteria tab, select the following:

      Student, Student Progression, Academic Year [equals] [year]

      AND Student, Student Progression, School [equals] [School]

      AND Student, Status Log, Status [equals] [Current Student status]

      AND Student, Status Log, Status Date [less than or equal to] [date]

      And Schedule, Academic year [equals] [year]

      And Schedule, Class term enrolled [equals] [Term]

      And Schedule, Class, Class ID [equals] [Homeroom Class ID]
     
    • On the Output tab, select Student, Bio 1, First name and Last name.
     
    • Select any other desired fields on the Output tab.
     
    • On the Sort tab, select Student, Bio 1, Last name.
     
    • Run the query.

    Note: There will be duplicates of the student records, especially if the current status of a student has been changed on different dates prior to the date.  
    • On the Filters tab, select the query created in Step 1 for Students.
     
    • On the Output tab, select Student, First name and Last name.
     
    • Select any other desired fields on the Output tab.
     
    • Click Export Now and export to Excel.
     
    • Total the rows to get the number of students.