Create a query from a filter in a table, query, or form

Create a query from a filter in a table, query, or form

Instead of designing a query from scratch in query Design view, you can create it automatically by saving an existing filter in a table, query, or form as a query. A query offers more flexibility than a filter. For more information, click .

  1. With the filter displayed in the Filter By Form window or the Advanced Filter/Sort window, click Save As Query on the toolbar.

  2. Type a name for the query, and then click OK.

    The new query appears in the Database window. It automatically includes all the fields from the underlying table because the query's OutputAllFields property is automatically set to Yes, but you can change the query's design if necessary. For more information on modifying a query, including setting its properties, click .

Note   You can use the query as a filter, too. You might do this if you already saved one filter with the form or datasheet, and you want to use the query as a second filter.