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.
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).
Prerequisite: The SQL statement
must be open in the SQL Query Builder.
- 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.