Tuesday, November 29, 2016

Microsoft Access : How to filter by form and create an advanced filter



How to  filter by form  :
  1. In the Sort & Filter group on the Home tab, click Advanced and then click Filter By Form.
  2. In the Filter by Form window , on the Look for tab, enter the value in the field or fields you want to use as the filter. 
  3. Click the Or tab to set up OR conditions. 
  4. In the Sort & Filter group, click Toggle Filter to apply the filter. Click Toggle Filter again to remove the filter. 
 How to create an advanced filter :
  1. On the Home tab, in the Sort & Filter group, click Advanced,and then click Advanced Filter/Sort.
  2. In the Advanced Filter/Sort window , in the Field row in the grid, select the fields you want to use in the filter.
  3. In the Criteria row , specify the expression to use in the filter.
  4. In the Sort & Filter group, click Toggle Filter to apply the filter. Click Toggle Filter again to remove the filter.

No comments:

Post a Comment