Criteria – Filters

DBxtra allows to add any criteria – filter supported by the database you are connected to.

Important! If your Query is built from more then one database – Heterogeneous Query – then the MS Access SQL syntax is required.

Add a Filter

• Select the field Criteria and double click it.

• To add an Operator double click it .
• You can enter values manually or use the Values functionality.
• Click Show Values to load all values contained in the database.
• To select a value double click it.
• Click Ok to add the expression to the Query.