Columns displayed from Query

  • Thread starter Thread starter Newbie
  • Start date Start date
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.
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Acees Queries Hidden Column 1
How to re-order columns Programatically. Possible? 6
"#Deleted" is displayed in my cells 1
Run 2nd query using results from 1st query 0
Printing SQL query results in a list of columns, instead of one long column 1
Data Mismatch in Excel 2010 4
#Deleted being displayed in a linked table 5
Counting multiple memberships 1

Back
Top