Create an Expression

When you construct expressions in the Expression Builder window, the system does not check whether your syntax is correct. The Expression Builder window is simply an interface for selecting the criteria to include in the expression.

For the query in which you want to create a simple expression, access the Design workspace.
In the grid in the Conditions section, for the field on which you want to create the expression, in either the Criteria cell or the Or cell, select the button in the right side of the cell.

The Simple section of the Expression Builder window appears.
Using the fields provided, construct your expression.
Select Done.

The Expression Builder window closes, and in the grid in the Conditions section, <expr> appears in the field on which you created the expression. You can modify the expression directly in the Advanced section of the Expression Builder window.

For the query in which you want to create an advanced expression, access the Design workspace.
In the grid in the Missing variable reference section, in the appropriate Field, Criteria, or Or cell, select the gray button in the right side of the cell. If the Simple section is currently displayed, then select Advanced.

The Advanced section of the Expression Builder window appears.
Using the fields provided, construct your expression.
Select Done.

The Expression Builder window closes, and in the grid in the Conditions section, <expr> appears in the field on which you created the expression.

Tip: If you re-access the Expression Builder window via any cell, you can modify the expression directly in the Advanced section of the Expression Builder window, or you can modify previously made selections to update the expression.