Filter By Selection Access. Filter by selection a filter lets you see specific records in a table form query or report. Access applies the filter.
For example if the value 2 21 1967 is currently selected in the birthdate field on the home tab in the sort filter group click selection to display the filter by selection commands and then select your filtering option. Select filter by selection from the shortcut menu. Use filter by selection to find all records with people who has a first name that begins with sam.
Place your cursor in the cell that contains the value you want to use as your filter value.
It assumes that your current selection is what you want to use as your filter value or criteria. Access applies the filter. When you filter by selection access 2007 returns the results to you as a subset of records in the table. You can also select the cell and then click the selection button on the home tab in the sort filter section to access the same list of choices.
