To specify the logical conditions to filter your table
data, you can use standard filter. You can specify up to three filter
conditions.
- Click .
- On the Standard Filter window:
- Select one between the logical operators AND / OR for
the operator.
- Specifies the field names from the current table to
set them in the argument for field names.
- Specifies the comparative operators through which the
entries in the Field name and Value fields can be linked for condition.
- Specifies a value to filter the field.
- Click OK
Here's an
example. To set the conditions have been
defined so that only the rows which contain January in the month field,
and a value greater than or equal to 160000 in the Standard field
are displayed.
- Specifies "Month" as the field names.
- Specifies "=" as the condition.
- Input "January" as the value of"Month".
- Select "AND" as the logical operators.
- Select "Standard" as the field names.
- Select ">=" as the condition.
- Input "160000" as the value of "Standard".