Add Condition dialog box enables you to add condition to a specified query.
The dialog box contains three sections:
This pull down menu includes all the database record fields available in your query. The format of strings in the pull down menu is Table.Field
This pull down menu lists logical and other operations performed when condition is set:
< | - if the Field value is less than the right operand of a binary operation; |
<= | - if the Field value is less than or equal to the right operand of a binary operation; |
<> | - if the Field value is not equal to the right operand of a binary operation; |
= | - if the Field value is equal to the right operand of a binary operation; |
> | - if the Field value is bigger than the right operand of a binary operation; |
>= | - if the Field value is bigger than or equal to the right operand of a binary operation; |
BEGINS WITH | - if the Field value begins with character(s) of the right operand of a binary operation; |
BETWEEN | - if the Field value is within the range defined by minimum and maximum values specified in the Value section; in this case you must enter the two values in the Value section. |
CONTAINS | - if the Field value contains character(s) displayed in the Value section; |
ENDS WITH | - if the Field value ends with character(s) displayed in the Value section. |
In these folder tabs, you can choose or enter values for a binary operation. Values can be inserted as fixed numbers or strings in the Value folder tab, or chosen from the Form Control pull down menu of the Control folder tab.
Value tab
A fixed value can be typed in a text line.
Control tab
This tab contains a pull-down menu. This pull down menu lists names of all previously chosen form controls included in your form.
When you choose the BETWEEN option in the Operation menu, the Right Operand section Control folder displays two controls instead of one. They show the upper and lower limits of a binary operation.
In the event you chose the Select command in the Database Query dialog box, one more optional tab will become available.
Join tab
This folder tab provides you with options to merge tables within a chosen Database. Set a relationship between fields of two different tables. Do not choose a binary operation other than the Equal operation.
Press OK to apply the condition to your query.