Filtering is a sophisticated means of finding more than one record in a database table. Query a database table if you frequently use the same criteria to gather information or you want to include information from more than one database table.
When you filter a database table, you can use standard comparison operators to find records whose values are greater than, less than, equal to, less than or equal to, greater than or equal to, or not equal to a value that you enter. For example, you could find items of a certain kind that cost $20 or more. However, you can't use expressions to find records whose values fall within a certain range. In other words, to find items that cost between $20 and $22, you can't filter a database table. To do that, you have to construct a query.
Access remembers the last filtering operation you did so you can filter in the same way a second time, but you can't store several different filtering criteria and call on each one whenever you need it. You can, however, save the results of a filtering operation in a form or report.
By the way, it is possible to filter the results of a query. To do so, open the query on the Queries tab of the Datasheet window and then give a filtering command.