You can use expressions to create filters. When you apply a filter, you evaluate each record according to a logical expression. For your expression to be valid, it must be logical; that is, it must have a true or false result. Only the records which are answered as true are selected. For example, you can use the expression SALEPR>100 to create a filter that would select all prices over $100 in a column called “Sale Price”. The condition is that a sale price must be over $100. The effect is to filter out all sale prices of $100 and under.
There are two types of filters: global and local. A global filter applies to all commands whether submitted from the menu, button bar or in command mode and to all Views for a table layout. Global filters stay in place until removed or until the file is closed. A local filter is applied to a single command when it is being executed.
You can create filters at any time using the Expression Builder or when creating or editing a table layout. You can also create and apply global filters directly from the View. Depending on the method you choose, filters can be named, saved and reused when required. For information on accessing the Expression Builder, see Using the Expression Builder.
For information about creating and applying data filters when defining data fields in a table layout, see Creating a Data Filter.