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 

No comments:

Post a Comment