Column Menu

Restriction: This topic applies to Windows environments only.

The options found in the Column menu are applied to the currently selected column (or columns) of the Query Conditions Grid on the Query Design window. To select a column, double click the column name displayed in the Query Conditions Grid.

Note:

The Column menu that appears when working on a Query is different from the Column menu that appears when viewing a Query Result window.

Create Computed Column Displays the Create Computed Column dialog box, so that you can define a column based on an expression.
Hide Column Sets the currently selected column to hidden mode, so that it will not be included in the SELECT clause of the query. If a column is hidden before you run the query, you will not be able to select it from the hidden column list in the Query Result window.
Select Hidden Column Displays the Select Hidden Column dialog box, and lets you move columns between a list of hidden columns and a list of displayed columns.
Sort Column Displays the Sort Column submenu. When you pick either ascending or descending order from the submenu, the currently selected columns will be added to the Order By clause with the appropriate sequence.
Function Displays the Function submenu. When you pick a function, the current column is converted into a computed column by using it as an argument for the function. Since the functions are all aggregate functions, the computed columns defined will retrieve summary rows. For the current column you can:
Delete Column Deletes the currently selected column(s) from the Query Conditions Grid.