Access’s most powerful type of filter is the Advanced Filter, which is used to sort multiple fields, apply complex filter criteria and expressions, as well as apply multiple AND/OR statements. Advanced Filters have many advantages. They have the ability to:
Sort by multiple fields: You can sort records using several fields. For example, you could sort a table alphabetically by last name and then by first name.
Use complex filter criteria and expressions: You can use advanced expressions and operators to search for data. For example, you could filter for dates that fall Between 1/1/95 And 12/31/99.
Use multiple AND/OR statements: You can use more than one criterion to sift through records. For example, you could filter for employees who are from Washington AND who have been with the company for more than five years.