Choosing Columns

There may be times when you do not want to show all of the columns in a table in your result. You can specify which columns to show, and the order in which they will appear in the Result window.

To add a single column to the Query Conditions Grid:

  1. Open or create a new query.
  2. Scroll through the list in the Column Selection List to find the column you want to add.
  3. Click the column to add it to the Query Conditions Grid. The column will be highlighted in the Column Selection List to show that it is added to the grid.
  4. Continue adding columns by clicking on them. As you click the names, they appear in the Query Conditions Grid. If you click a name by mistake, click it again to remove it.

    Notice that as you add a column to the query, it is added at the end of the set of columns in the Query Conditions Grid.

Note: If you decide you do not like your current column selection, you can easily start over by clicking once on the asterisk in the Column Selection List to select all columns, and a second time to remove all columns from the Query Conditions Grid.