How to use a query as a filter :
- On the Home tab, in the Sort & Filter group, click Advanced and then click Advanced Filter/Sort.
 - Click Advanced again, and then choose Load from Query.
 - In the Applicable Filter dialog box, select the query you want to use as a filter, and then click OK.
 - In the Sort & Filter group, click Toggle Filter to apply the filter. Click Toggle Filter again to remove the filter.
 
- On the Home tab, in the Sort & Filter group, click Advanced, and then click Advanced Filter/Sort.
 - In the Advanced Filter/Sort window , in the Field row in the grid, select the fields you want to use in the filter.
 - In the Criteria row , specify the expression to use in the filter.
 - Click Advanced, and then choose Save As Query.
 - Enter a name for the query in the Save As Query dialog box, and then click OK
 
No comments:
Post a Comment