Microsoft Access : How to filter by a field and by selection in datasheet view
How to filter by a field in Datasheet view :
- Select the field you want to filter by, and then click Filter in the Sort & Filter group on the Home tab.
- In the menu that Access displays, clear the check box for Select All.
- Select the check box for each field value you want to view, and then click OK
How to filter by selection in Datasheet view :
- Select the value or the portion of a value you want to use as the filter.
- In the Sort & Filter group on the Home tab, click Selection.
- In the menu Access displays, select the expression for the filter (Equals, Does Not Equal, or another filtering option).
- Click Toggle Filter to remove the filter from the table.
No comments:
Post a Comment