Placement of Columns in Database Query

[jgoebel]

I have an existing database query that will query the
dbase and return the results to an excel worksheet. The
query wizard is split into two windows: The window on the
left will allow you to select columns from tables that you
would like to display. When these columns are moved to the
window on the right, they become part of the query. My
problem is that when I come back at a later date to edit
the query and insert a new column, I can only get the new
column to display at the end of the worksheet. There are
two arrow buttons on the right hand side of the screen
that allow me to move the newly added columns freely
throughout the list of columns to be returned, but when I
complete editing the query using the wizard, the newly
added column continues to display at the end of the
columns in the query rather than where I placed it in the
list. Any Suggestions?

 

[Dick Kusleika]

jboebel

On the External Data Toolbar, click the Data Range Properties button. In
that dialog, uncheck the Preserve Column Sort/Filter/Layout checkbox.
Refresh if necessary.