Create New Columns from Existing Columns or Functions

Create Calculated Fields

Use Calculated Fields to create a new column that is calculated from other columns or functions and assign the new column to a table in the query.

To create a new column from an existing column or function

1. Click Edit calculated fields in the Query Builder toolbar.

2. Review the following for additional information:

   New field name	Click + to add the column to the list of defined fields.
   Defined fields	Select a column for which you want to define fields from the list.
   Field definition	Double-click the columns or calculated fields and the appropriate functions or operators to include in the calculated field (i.e., FIRST_NAME + ’r; ’r; + LAST_NAME).
   Attach to table	Select the table that you want to attach to the calculated field.

Related Topics

Build Queries Visually