Changing Output Column Order Format??

[Bill]

If save a query it seems to save the position of the out columns too. If I
then move things around in the QBE grid the output columns don't change to
the new column positions and I have to do it manually.

Is there anyway I can set the query to list the columns as they are in the
QBE grid please?

Thanks for ant help.

Bill

 

[Jerry Whittle]

Probably your best bet is to open the query in SQL view and move the columns
there to the order you want. Then save the query. The big trick it to never
open it in the QBE design view again as Access might rewrite the query on you.

 

[John Spencer]

The easiest way to get the columns back in order is to
-- open the query in SQL view,
--copy the SQL statement,
--Open a new query - don't select any tables
--Switch to SQL view
--Paste the SQL into the window
--Save the query with the appropriate name

The position of the columns in a query is only saved if you are in
datasheet view and move the columns around. If you don't move the
columns in datasheet view they will always be in the same order as
design view. If you move them in design view (and only in design view),
they will be moved when you open the query in datasheet view.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[Bill]

Ok, thanks to you both.
Regards.
Bill