Resetting Column Order after unfreezing a column

[ES]

In my query, I've frozen a few columns to the left side. After I've done
whatever I needed to do, I unfroze the column, but the column order did not
reset. I've resorted within the design view and the new sort order doesn't
appear on the datasheet view but it is retained in the design view. I've
also tried compacting/repairing and recopy the query.

How do you reset the column sort order?

 

[John Spencer]

Open the query in SQL view
Copy the SQL statement
Open a NEW query (don't add any tables)
Switch to SQL View
Paste the SQL Statement
Save and run the new query.

Other choice is to drag the column headers of your current query into
whatever order you wish to see them. When asked if you want to save the
changes to the LAYOUT of the query say yes. If you want to revert to the
layout that was there when you opened the query say No.

Access does not store the layout UNTIL you make a change in Datasheet view
and save that change.

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Jerry Whittle]

What version of Access? I had no trouble with 2003.

Please post the SQL that isn't working and a short example of the data which
isn't sorting correctly.