When you add new fields to a query they are automatically added to the fields list. Reordering the Fields Rearrange columns. Make Business Unit the first column, followed by DeptID and JobCode: Click on the Fields tab Click Reorder/Sort button (right side of screen) The Edit Field Ordering tab appears. To the left of each field is a text box you can use to identify a new column location. To the right of each field is a text box you can use to specify a sort order Locate BUSINESS_UNIT field In the corresponding New Column text box, type: 1 Locate DEPTID field In the corresponding New Column text box, type: 2 Locate JOBCODE field In the corresponding text box, type: New Column 3 Note: You don’t have to reorder all of the fields if you don’t want to, it is to take what you identified as columns 1, 2 and 3 and reorder the rest of the fields in the same order they are. For instance what is now number 1 will become number 4, number 2 will become number 5, etc. Sorting the Query Results Sort the result by DeptID and JobCode
When you add new fields to a query they are automatically added to the fields list. Reordering the Fields Rearrange columns. Make Business Unit the first column, followed by DeptID and JobCode: Click on the Fields tab Click Reorder/Sort button (right side of screen) The Edit Field Ordering tab appears. To the left of each field is a text box you can use to identify a new column location. To the right of each field is a text box you can use to specify a sort order Locate BUSINESS_UNIT field In the corresponding New Column text box, type: 1 Locate DEPTID field In the corresponding New Column text box, type: 2 Locate JOBCODE field In the corresponding New Column text box, type: 3 Note: You don’t have to reorder all of the fields if you don’t want to, it is to take what you identified as columns 1, 2 and 3 and reorder the rest of the fields in the same order they are. For instance what is now number 1 will become number 4, number 2 will become number 5, etc. Sorting the Query Results Sort the result by DeptID and JobCode
2017-10-HRMS-Query-Training.docx