Use the Expression Builder to build SQL expressions for SQL and prompted queries.
The Expression Builder contains a palette of common elements used for creating SQL expressions. Examples of these elements include column names, constants, functions, and operators. When you click a button on the Expression Builder palette, a template for the expression element is inserted into the SQL query window or prompted query window. The end-result is a framework on which you can build the SQL or prompted query.
When you are through building the expression, click outside of the Expression Builder window or press Esc to close the window.