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
-
Click Edit calculated fields
in the Query Builder toolbar.
-
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.