Materi Microsoft Access : How 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