Tuesday, November 29, 2016

Microsoft Access : How to filter by a field and by selection in datasheet view

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

No comments:

Post a Comment