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