Wednesday, November 30, 2016

Microsoft Access : How to use a query as a filter and save a filter as a query



How to  use a query as a filter :
  1. On the Home tab, in the Sort & Filter group, click Advanced and then click Advanced Filter/Sort.
  2. Click Advanced again, and then choose Load from Query.
  3. In the Applicable Filter dialog box, select the query you want to use as a filter, and then click OK.
  4. In the Sort & Filter group, click Toggle Filter to apply the filter. Click Toggle Filter again to remove the filter. 
 How to  save a filter as a query :
  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. Click Advanced, and then choose Save As Query.
  5. Enter a name for the query in the Save As Query dialog box, and then click OK 

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.