A - Click on the "Select & Sort" on the tab control.

B - On the top part of the "Select & Sort" tab enter your selection criteria. This works for the Master table only.

    1 - In the "Select Field" drop down list, pick the field "ClassOf".
          The "Data Type" textbox is automatically populated.
          In the "Relationship" drop down list, pick "Equal".
          Click the "User Supplies At Runtime" radio button.
          Enter "2005" as the default value.
          Type in "Enter Class to Print:" as the "Prompt" to appear at runtime.

    2 - In the "Select Field" drop down list, pick the field "Gender".
          The "Data Type" textbox is automatically populated.
          The conjunction drop down will automatically change to "AND".
          You can select "OR" if that's what your report requires. We need "AND" here.
          In the "Relationship" drop down list, pick "Equal".
          Click the "Constant" radio button.
          Type "m" as the constant to select only Males.

    3 - In the "Select Field" drop down list, pick the field "Enroll_Status".
          The "Data Type" textbox is automatically populated.
          The conjunction drop down will automatically change to "AND".
          You can select "OR" if that's what your report requires. We need "AND" here.
          In the "Relationship" drop down list, pick "Equal".
          Click the "Constant" radio button.
          Type "0" as the constant to select only currently enrolled students.
 

C - On the bottom part of the "Select & Sort" tab enter your sort criteria. This works for the Master table only.

     1 - In the "Field to Sort" drop down list select the field "LastFirst".
          The "Data Type" textbox is automatically populated.
          For the "Direction" of the sort select the "Ascending" radio button.