Use Filter by Selection to change query output in Access

Did you know that you can filter your Access forms to display exactly the results you want right in front of you? Here's how to use the Filter by Selection option.

You just created a query that adds a new field to your Employee table. The new field calculates the date when each employee will by fully vested in the company pension plan. Now you want a listing of next year's newly vested employees.

Instead of going back into Query Design View and changing the criteria for the Vested_Date field, you can filter the results right in the Query Datasheet view. Follow these steps:

  1. Run the query.
  2. Find a record that has a vested data in the year 2007.
  3. Select 2007 in that field.
  4. Right-click the table.
  5. Select Filter By Selection.

The query results will now list only those records whose employees have a 2007 vested date. To return the list to the original query results, click the Remove Filter button in the default Query datasheet toolbar.

Miss a tip?

Check out the Microsoft Access archive, and catch up on our most recent Access tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks

Free Newsletters, In your Inbox