Filter By Selection
Advanced Filter/Sort
all at once)
or Sort Descending 
on the toolbar) or Sort Descending on the toolbar)| What do you want the filter to do? | Filter By Selection |
Filter By Form and Filter For Input | Advanced Filter/Sort |
|---|---|---|---|
| Search for records that meet multiple criteria. | Yes (but you must specify the criteria one at a time) | Yes (and you can specify the criteria all at once) |
Yes (and you can specify the criteria all at once) |
| Search for records that meet one criteria or another criteria. | No | Yes | Yes |
| Allow you to enter expressions as criteria. | No | Yes | Yes |
| Sort records in ascending or descending order. | No (however, after applying the filter, you can sort all filtered records by clicking Sort Ascending or Sort Descending on the toolbar) |
No (however, after applying the filter, you can sort all filtered records by clicking Sort Ascending or Sort Descending on the toolbar) |
Yes (you can sort some fields in ascending order and other fields in descending order) |