Similarities and differences between select queries and filters

The basic similarity between select queries and filters is that they both retrieve a subset of records from an underlying table or query. How you want to use the records that are returned determines whether you use a filter or a query.

Generally, use a filter to temporarily view or edit a subset of records while you're in a form or datasheet. Use a query if you want to do any or all of the following:

• View the subset of records without first opening a specific table or form.
  
  
• Choose the tables containing the records you want to work with and add more tables at a later date if necessary.
  
  
• Control which fields from the subset of records display in the results.
  
  
• Perform calculations on values in fields.

Note   Even if you determine you need a query, consider taking advantage of the easy Filter By Form, Filter By Selection, or Filter For Input techniques for creating a filter, and then saving the filter as a query. This enables you to bypass the query's design grid altogether (unless you want to make additional changes to the query). Even so, when you open the query in Design view, you'll see how Microsoft Access filled in the design grid using the information from the filter. You can then use this information as a guide for making additional changes.

The following table identifies the similarities and differences between queries and filters.