Editing expressions in the Expression Builder wizard

You can use the Expression Builder wizard to edit complex expressions or subqueries. An expression specifies a value.

Before you begin

You can start the Expression Builder wizard from anywhere in the SQL Query Builder where you can use an expression in a statement (for example, the Column column in the Design pane of a SELECT statement).

The SQL statement must be open in the SQL Query Builder.

Procedure

To edit an expression:

  1. In the Design pane of the SQL Query Builder, double-click the cell in which you want to edit the expression.
  2. Click Edit Expression in the list. The Expression Builder wizard opens to the page for defining that type of expression .
  3. Specify information for the fields on the page, and then click Finish.

Feedback