• Create a dynamic student query
    • On the Criteria tab, select the fields to group the students. For example:
      • Expand the Student category and the Bio 1 subcategory. Select the Current Grade field and set the operator to equals or one of.
      • Expand the Student category and the Bio 2 subcategory. Select the Locker number field and set the operator to not blank.
    • On the Output tab, select the fields to appear in the query results. For example:
      • Expand the Student category and the Bio 1 subcategory. Select the following fields: Full name, Student ID, Current school, Current Grade, and Homeroom teacher.
      • Expand the Student category and the Bio 2 subcategory. Select the Locker number and Locker combination fields.
    • On the Sort tab, select the order of the records in the results. For example, expand the Student category and the Bio 1 subcategory. Select the following fields: Current School (Asc), Current Grade (Asc), and Last name (Asc).
    • Select File, Save from the menu bar
    • Name and save the query
    • Select the Results tab or click Run