Use AutoFilter to filter the query results first to show only records where value in the StaffID field is Mo and the value in the IncreaseType field is Merit.
Question
Use AutoFilter to filter the query results first to show only records where value in the StaffID
field is Mo
and the value in the IncreaseType
field is Merit
.
Solution
Sure, here are the steps to use AutoFilter in Excel to filter your query results:
-
Open your Excel spreadsheet that contains the data you want to filter.
-
Click anywhere inside the data set.
-
Go to the "Data" tab in the Excel Ribbon.
-
In the "Sort & Filter" group, click on "Filter". This will add drop-down arrows to each column header.
-
Now, go to the "StaffID" column and click on the drop-down arrow.
-
In the search box, type "Mo" and then click on "OK". This will filter the "StaffID" column to only show records where the value is "Mo".
-
Next, go to the "IncreaseType" column and click on the drop-down arrow.
-
In the search box, type "Merit" and then click on "OK". This will filter the "IncreaseType" column to only show records where the value is "Merit".
Now, your data set should only show records where the "StaffID" is "Mo" and the "IncreaseType" is "Merit".
Similar Questions
Use AutoFilter to filter the query results to show only records where the value of the StaffID field is Mo or Shannon.Font Size
Which of the below queries displays employees' name and new salary after the increment of 1000
From the current view (Design view), change the Field Size property for the StaffID field to 7.
Write a query to modify the datatype of the column departmentId from VARCHAR(30) to INT in the table 'department'.Refer to the existing table DLL given below:
Write a query to display all the customers whose ID is 2001 below the salesperson ID of Mc Lyon.
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.