If a filter is applied to the Amount field of a table, i. How will you check what filter criteria has been applied?
Answers
Answer:
Open a table, query, form, or report in any of the following views: Datasheet, Form, Report, or Layout.
Make sure that the view is not already filtered. On the record selector bar, verify that either the Unfiltered or the dimmed No Filter icon is present.
Tip: To remove all the filters for a particular object, on the Home tab, in the Sort & Filter group, click Advanced, and then click Clear All Filters.
Click anywhere in the column or control that corresponds to the first field that you want to filter and, on the Home tab, in the Sort & Filter group, click Filter
To apply a common filter: Point to Text (or Number or Date) Filters, and then click the filter that you want. Filters such as Equals and Between prompt you to enter the necessary values.
Explanation:
it will help you to understand