Filtering with the Filter Row

This method allows you to filter records in a grid by entering the filtering conditions in the Filter Row. This row, when enabled, appears below the column headings. As soon as you enter the filtering conditions, the records immediately get filtered and the filtering conditions appear in the Condition Panel.

To filter records using the Filter Row:

  1. If the grid does not show the Filter Row, right-click anywhere in the list and select Filter > Filter Row from the pop-up menu.

  2. In the Filter Row, enter a filtering condition for a field in the corresponding column, as described in the following table:

Type of field Steps to enter a filtering condition

String, memo or lookup

To display records in which values in this field begin with some particular characters, type those characters.

The string of characters that you type can include wildcards: "_" to represent any single character and "%" to represent any sequence of characters.

Integer or currency

To display records in which this field contains a particular value, type this value.

Date or date/time

To display records in which this field contains a particular date, either type that date or click the cell, then click the down arrow that appears, and select that date from the calendar.

Logical

To display records in which this field’s value equals TRUE, click in the Filter Row under the corresponding column heading so that a check mark appears.

To display records in which this field’s value equals FALSE, double-click in the Filter Row under the corresponding column heading.

  1. Repeat the previous step for every field you want to filter the records by.