DBWebApplications 





Refining Access Queries  «Prev 

Applying filters to queries

Filtering Access database by Form and Selection

  1. To start with, you will use this query called qryClientsAndProjects in the project database. Click the View button to work with the results of this query.
  2. You now have the results set, with the client named “Network Consultants, Inc.” highlighted. For the first part of this simulation you will practice using Filter by Selection. Click the Filter by Selection toolbar button.
  3. Now you can see the four records filtered from the rest of the query’s result set. Remove the filter by clicking the Remove Filter toolbar button.
  4. Here are all the records once again. Now it’s time to work with the Filter by Form feature. Click on the Filter by Form toolbar button.
  5. You can see the filter you just set with the Filter by Selection feature. At this point, you are going to choose a different company for which to filter. Click the arrow in the drop-down list for the Company field.
  6. Now click on the company called “ABC Webworks”.
  7. The company chosen will be displayed in the Company drop-down. Now it’s time to apply the filter. Click the Apply Filter button.
  8. There you go; the new results with the applied filter.

Apply a filter to view select records in an Access database

Filtering is a useful way to see only the data that you want displayed. You can use filters to display specific records in a form, report, query, or datasheet, or to print only certain records from a report, table, or query. By applying a filter, you are able to limit the data in a view without altering the design of the underlying object. This article explains the types of filters in Access and how to apply, save or remove filters in an Access 2010 client database. This article does not apply to filtering records in an Access 2010 web database.

How filters are useful

Since the view you get after you apply a filter contains only records with the values that you selected, the rest of the data remains hidden until you clear the filter.
Note Columns in datasheets and controls in forms and reports that are bound to expressions do not support filtering. There are several types of filters and some of them are easy to apply and remove. Access 2010 contains some common filters that are built into every view. The availability of filter commands depends on the type and values of the field. For example, to view the records of people whose birthdays fall during a specific month, click the BirthDate column, on the Home tab in the Sort and Filter group, click Date Filters, and then select the required date period.
Filter By Form
Filter By Form