You can use the Expression Builder wizard to replace expressions
or subqueries that you have defined.
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 replace an expression:
- In the Design pane of the SQL Query Builder, double-click
the cell in which you want to replace the expression.
- Click Replace Expression in the
list. The Expression Builder wizard opens.
- Select the type of expression that you want to replace
the existing expression, and then click Next.
- Specify information for the fields in the wizard, and then
click Finish.