Evaluate an expression

When Data Item names have been used in an expression, the expression cannot be evaluated unless the value of the Data Items is known. This Wizard enables temporary values to be given to each Data Item so that the expression can be evaluated. Take for example the expression Mid([AccountName], 1, 3) . If [AccountName] is replaced by "Fred Bloggs", the expression Mid("Fred Bloggs", 1, 4) can be evaluated to give a the result "Fred".

  1. Enter Data Item Values.

    Enter a value for each Data Item identified in the expression.

  2. Test

    Select the Test button to obtain the result of the expression. Select OK or Cancel to return to the Expression Editor.