Filter a list of records on forms to show only those records that meet your specified criteria. Specify sort criteria to select the order in which to sort a list of records.
To define filter and sort criteria:
-
Open any form containing a list of records, and then click Filter.
-
Specify this information:
Filter - Select the field on which to filter from the first Select drop-down list.
The operator field is available for filtering numeric and date fields only.
-
Select an operator from the second drop-down list. See the following table for operator options:
Operator
Definition
= (equal to)
Search for items with a value equal to the entered value.
> (greater than)
Search for items with a value greater than the entered value.
< (less than)
Search for items with a value less than the entered value.
-
Specify the value for which to filter in the third field.
-
Select one of these join operators:
Option
Description
Select And.
Include records that include all joined conditions
Select Or.
Include records that contain one or the other condition.
-
Specify additional conditions by which to filter as necessary.
-
Specify this information:
Sort - Select the first field by which to sort the records.
-
Click Sort to select Sort Ascending or Sort Descending.
-
Specify additional fields by which to sort as necessary.
To remove sort criteria, choose Select from the Sort drop-down lists.
-
Click Apply.
The filter on the form is automatically saved. To indicate that a form has a defined filter, the filter button is shown.