Columns displayed from Query

N

Newbie

The query uses information from 6 unique tables that are
linked to a mainframe.

In the query, columns are listed in the order I would like
to see them. When executing the query, the output list
does not display the columns in the order needed.

Is there a command that can be used in the query to
establish the output in a fixed format.
 
V

Van T. Dinh

The order of the Columns in the DatasheetView may be
different from the order of the Columns in DesignView.

In the DataSheetView, simply click, dold and drag the
Column(s) to where you want.

HTH
Van T. Dinh
MVP (Access)
 
Top