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:
- In the Design pane of the SQL Query Builder, double-click
the cell in which you want to edit the expression.
- Click Edit Expression in the list. The Expression Builder wizard opens to the page for defining
that type of expression .
- Specify information for the fields on the page, and then
click Finish.