Sort the query by Last Name by typing a 1 in Order By” in the “New LAST_NAME column. Click OK Save the file as NDU_FL_LAB_P1. Use as a description Employees for “Select a Dept”. Click OK Click on the button on the FULL_PART_TIME field “EDIT” Change the XLAT Value to and “Short” Click the button “OK” Add a runtime prompt for the Business Unit Remember: You do not have to select the Business Unit field in the query to do this.
Sort the query by Last Name by typing a 1 in “New Order By” in the LAST_NAME column. Click OK Save the file as NDU_FL_LAB_P1. Use as a description “Select Employees for a Dept”. Click OK Click on the “EDIT” button on the FULL_PART_TIME field Change the XLAT Value to “Short” and Click the “OK” button Add a runtime prompt for the Business Unit Remember: You do not have to select the Business Unit field in the query to do this.
2017-10-HRMS-Query-Training.docx