Filter By Selection Access. Select an option from the menu. It assumes that your current selection is what you want to use as your filter value or criteria.
Filter by selection a filter lets you see specific records in a table form query or report. Place your cursor in the cell that contains the value you want to use as your filter value. Access immediately displays a table containing only the records matching your selection.
Another way to access the selection filter options is to right click the specific cell.
Access shows only those records matching the filter by selection criterion. 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. Another way to filter by selection is. Access shows only those records matching the filter by selection criterion.
