Standard Filter

Specifies the logical conditions to filter your table data. This dialog is available for spreadsheet documents, database tables and database forms. The dialog for databases does not contain the More Options button.

若要使用此指令...

From the menu bar:

Choose Data - More Filters - Standard Filter.

From the tabbed interface:

Choose Data - Standard Filter.

On the Data menu of the Data tab, choose Standard Filter.

From toolbars:

Icon Standard Filter

標準篩選


篩選條件

您可以透過指定線條類型、欄位名稱、邏輯條件和數值或引數組合來定義篩選。

連結

For the following arguments, you can choose between the logical operators AND / OR.

欄位名稱

Specifies the field names from the current table to set them in the argument. You will see the column identifiers if no text is available for the field names.

條件

Specifies the comparative operators through which the entries in the Field name and Value fields can be linked.

數值

Specifies a value to filter the field.

[數值]清單方塊中包含指定的[欄位名稱]中所有可能的值。選擇在篩選中要使用的值。您也可以選擇[- 空缺 -][- 不空缺 -]條目。

如果使用資料庫表格或表單中的篩選功能,請在[數值]文字方塊中鍵入用於篩選的數值。

Please support us!