Reorder output columns in a query (ADP)

Microsoft Office Access 2003

previous page next page
  1. In the Database window, click Queries Button image 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 (Button image).
  3. Point to the row selector button and drag the row to a new location.

ShowReorder columns for output in the SQL pane

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

    ShowTip

    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.

previous page start next page