|
Navigation: Appendix > Query Wizard > Manual Query > Expression Builder |
|
|
|
|
|
Navigation: Appendix > Query Wizard > Manual Query > Expression Builder |
|
|
|
|
Expression Builder Fields:
| Query | Query. |
| Data/function categories | Data and function categories. |
| Data/function names | Data and function names. |
Controls:
| + | Addition. |
| - | Subtraction. |
| x | Multiplication. |
 | Division. |
| % | Modulus division. |
| ^ | Exponentiation. |
| < | Less than. |
| > | Greater than. |
| = | Equal to. |
| <> | Not equal to. |
| <= | Less than or equal to. |
| >= | Greater than or equal to. |
| (..) | Logical grouping. |
| & | Concatenation. |
| And | Boolean AND. |
| Or | Boolean OR. |
| Not | Boolean (logical) NOT. |
| Validate | Validate the expression. |
| Clear | Clear the expression. |
| Insert | Insert the highlighted data/function name into the expression. |
| Save | Close window and save any changes you have made. |
| Close | Close window. |
Page url: http://help.moveadminister.co.uk/expressionbuilder.htm
