Reorder Output Columns in a Query

The order in which you add data columns to a Select query determines the order in which they appear in the results. The first column you add to the query appears leftmost in the results, the second column next, and so on.

If you are creating Update or Append queries, the order in which you add columns affects the order in which data is processed.

To control where a data column appears in the result set, or in what order it is used, you can reorder the columns.

Reorder columns for output in the Grid pane

1. In the Database window, click Queries   under Objects, click the query you want to open, and then click Design on the database window toolbar.
2. In the Grid pane, select the row containing the column by clicking the row selector button to the left of the row ().
3. Point to the row selector button and drag the row to a new location.

Reorder columns for output in the SQL pane

1. In the Database window, click Queries   under Objects, click the query you want to open, and then click Design on the database window toolbar.
2. If necessary, click SQL to show the SQL pane.
3. Edit the order of the column names in the SQL pane.

   Tip

   You can add a data row at a specific location in the Grid pane by inserting a blank row into the Grid pane, and then specifying the data column to insert.