You can only delete a filter created using Server Filter By Form, you can't temporarily remove it and reapply the same one later on.
- In the Server Filter By Form window, click Clear Grid
on the toolbar. - Click Apply Server Filter
on the toolbar.
Remove a filter from a table, query, or form and show all records
- To remove a filter and show the records that were displayed previously in the table, query, or form, click Remove Filter
on the toolbar in Form view or Datasheet view. - To remove a filter in a multiuser (shared) database and see which records have been added, deleted, or changed since you opened the table, query, or form, click Remove Filter/Sort on the Records menu in Form view or Datasheet view.
Remove a filter to show all records in a data access page in Page view
- Open a data access page in Page view.
- Click Filter Toggle
on the record navigation toolbar so that it is not selected.
Notes
- Removing a filter doesn't delete it. You can reapply a filter during the current working session by clicking the Filter Toggle button on the record navigation toolbar so that it is selected.
- This procedure doesn't apply to a Microsoft Office PivotTable Component, Spreadsheet Component, or Chart Component. These features can be filtered independently from the rest of the data on the data access page, and may also support additional filtering capabilities. For more information, click Help
on that component's toolbar.
Remove a filter data in a PivotTable or PivotChart view
Remove a filter from a PivotTable view
When items in a field are hidden by filtering a field or filtering by selection, the arrow 
in the field label is blue. When items are hidden by filtering for top or bottom values, the filtered field displays a funnel icon 
to the left of the arrow.
- Open a datasheet or form in PivotTable view.
- Do one or more of the following:
-
Click the AutoFilter button
on the PivotTable toolbar so that it is not selected.
Note If you click AutoFilter
again to turn filtering back on, the previously set filters will be reapplied.
Remove an autofilter, or a filter by selection, from a field
-
Click the blue arrow
of the field from which you want to remove the filter. -
Select the (All) check box and click OK.
Remove a conditional filter from a field
-
Select the field from which you want to remove conditional filtering.
-
On the PivotTable toolbar, click Show Top/Bottom Items
, and then click Show All.
Note If you don't want to retain your filters, make sure the AutoFilter button is not selected before you start selecting items to filter. If the button is not selected, selecting new items to filter automatically turns filtering on and removes your former filter settings.
Remove a filter from a PivotChart view
When items in a field are hidden by filtering a field or filtering by selection, the arrow in the field label is blue.
- Open a datasheet or form in PivotChart view.
- Do one of the following:
- Click the AutoFilter button on the PivotChart toolbar so that it is not selected.
Note If you click AutoFilter
again to turn filtering back on, the previously set filters will be reapplied.Remove an autofilter from a field- Click the blue arrow of the field from which you want to remove the filter.
- Select the (All) check box and click OK.
Remove a conditional filter from a field- Select the field from which you want to remove conditional filtering.
- On the PivotChart toolbar, click Show Top/Bottom Items
, and then click Show All.
- Click the AutoFilter button
Note If you don't want to retain your filters, make sure the AutoFilter button is not selected before you start selecting items to filter. If the button is not selected, selecting new items to filter automatically turns filtering on and removes your former filter settings.