Use AutoFilter to filter the query results to show only records where the value of the StaffID field is Mo or Shannon.Font Size
Question
Use AutoFilter to filter the query results to show only records where the value of the StaffID field is Mo or Shannon.
Solution
Sure, here are the steps to use AutoFilter in Microsoft Excel to filter your query results:
-
Open your Excel workbook and navigate to the worksheet that contains your data.
-
Click anywhere inside the data set that you want to filter.
-
Go to the "Data" tab on the Ribbon, then in the "Sort & Filter" group, click "Filter". This will add drop-down arrows to each column header.
-
Locate the column labeled "StaffID". Click the drop-down arrow next to the column header.
-
In the drop-down menu, uncheck the "Select All" box to remove all current filters.
-
Scroll through the list and check the boxes next to "Mo" and "Shannon".
-
Click "OK". The data in your worksheet will now be filtered to show only records where the StaffID is either "Mo" or "Shannon".
Remember, the filter will remain in place until you clear it. To clear the filter, click the "Filter" button in the "Sort & Filter" group on the "Data" tab.
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
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.
From the current view (Design view), change the Field Size property for the StaffID field to 7.
How do you select all the records from a table named staff where the value in last_name column begins with "Stark"?
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.