Query Property Sheet Columns Tab

This tab lists the columns in the SELECT clause, which specify what data will be displayed in the query.

You can add or delete columns as appropriate, and reorder the columns in the list using the arrows at the bottom of the tab. Any changes you make will propagate to the query's SQL tab and to the SQL Query tab of the parent view.

  1. Click in the first empty row in the list.
  2. Select a column from the list. You can add all the columns in a table by selecting a list entry with the table name followed by an asterisk. To enter a more complex expression via the SQL Editor, click the ellipsis button to the right of the list.
  3. [optional] Enter an alias for the column in the Alias column.
Parent topic: Working with View Queries