Finding, Filtering, Sorting  «Prev 
Filter records using complex criteria

More advanced uses of Filters

You have learned the three main methods of filtering data in a datasheet in this module. You may wonder what more you can do with filters.
Once you have learned to filter a datasheet you can use that skill on any datasheet--even those created by a query. And perhaps an even more useful feature is that you can create a form or a report from a filtered datasheet, forms and reports can be formatted, so this is a great way to create output to show to other people. When you create a form or report from a filtered datasheet, the form or report inherits the filter. So when new data is added to the table, the form or report will reflect all the data in the table filtered with the filter you defined.

Another approach for finding a specific record is to use the options that Access provides for sorting and filtering records. You can sort the records in text fields in ascending or descending order, and in number fields from smallest to largest. To sort and filter records, use the related commands in the
Sort & Filter group. 
You can also right-click a column name in Datasheet view and then click Ascending or Descending, or click the arrow to the right of a column heading to display a menu with sorting and filtering options. When you filter records, only the records that match the filterís criteria are displayed. This lets you whittle down a long list of records to find just a few records among many.