Modify a filter (MDB)

1. To further limit a set of records that already has a filter applied, start with step 2. To change the criteria previously defined for a filter, first remove the filter if it is currently applied.

   How?

   Do one of the following:

   • 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.

   Note  Removing a filter doesn't delete it. You can reapply the filter by clicking Apply Filter on the toolbar. When you remove a filter from a datasheet, Microsoft Access also removes any filters you applied to any subdatasheet within it.

2. In Form or Datasheet view, select a value in the form, subform, datasheet, or subdatasheet that you want to use as criteria, and then click either Filter By Selection on the toolbar or right-click the value and click Filter Excluding Selection on the shortcut menu. Repeat this process until you have the records you want.

Note  You can also switch to the Filter By Form window or Advanced Filter/Sort window to change the criteria, including specifying alternative criteria (one criteria or another).

1. To further limit a set of records that already has a filter applied, start with step 2. To change the criteria previously defined for a filter, first remove the filter if it is currently applied.

   How?

   Do one of the following:

   • 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.

   Note  Removing a filter doesn't delete it. You can reapply the filter by clicking Apply Filter on the toolbar. When you remove a filter from a datasheet, Microsoft Access also removes any filters you applied to any subdatasheet within it.

2. In Form or Datasheet view, do one of the following:
   • Right-click the field you want to specify criteria for in the main form, datasheet, subform, or subdatasheet, and then in the Filter For box on the shortcut menu, type the value you want to use as criteria.
   • Right-click any field in the main form, datasheet, subform, subdatasheet, and specify the expression you want to use as criteria in the Filter For box.
3. Press TAB and repeat step 2 until you have the records you want.

Note  You can also switch to the Filter By Form window or Advanced Filter/Sort window to change the criteria.

You can modify the filter by adding to blank fields other values you want the filtered records to contain, deleting or changing values in a field, or making any of the following modifications.

1. Open the report in Design view, or if the report is already open, make sure it is selected in the Database window.
2. Click Properties on the toolbar to display the report's property sheet.
3. In the Filter property box, modify the SQL WHERE clause.

   Tip

   If you don't know SQL, first change the filter in the underlying table or query. Next, switch to Design view for the table or query and display its property sheet. Finally, copy the revised WHERE clause from the table's or query's Filter property to the Filter property for the report.