It is possible to filter our data view so that only certain records are displayed. We will use this functionality to display only products with a price of over $15. This feature works in a similar manner to the conditional formatting (albeit there is no formatting to be applied). To filter our data view, we follow these steps:
Right-click on our data view.
Select Show Common Control Tasks.
Select Filter: from the list.
Click on the first row to add our new clause.
Specify the following values:
a. Field Name =
Price (Number)b. Comparison =
Greater Thanc. Value =
15
Click OK.
You will notice that our data view now only displays the products that are priced over $15.
To remove the filtering, we follow the first three steps so that the Filter Criteria dialog appears again. We remove our criteria by right-clicking on the black arrow to the left of the criteria and selecting Remove. Finally, we click OK.