You can use the Expression Builder wizard to create complex
expressions or subqueries. An expression specifies a value. It can
be a simple value, consisting of only a constant or a column name,
or it can be more complex.
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 create an expression:
- In the Design pane of the SQL Query Builder, double-click
the cell in which you want to create the expression.
- Click Build Expression in the list
and then press Enter. The Expression Builder wizard opens.
- Select the type of expression that you want to build, and
then click Next.
- Specify information for the fields in the wizard, and then
click Finish.