Multiple field Table Sort

B

Bob Quintal

Bob,

If you select the column in the query design grid, you can use the
little bar at the top of the column to drag it to another position
within the grid. Either that, or delete the existing column, and
re-insert in the position you want it. I don't think there is any
reason to have the same field represented in two columns.
Click to expand...
I know how to move a column. One can also drag a column in datasheet
view, and save the query so that the column order is retained.

The original poster wanted a multi-column sort, with the layout of
columns differing from the sort sequence.

In order to do this, once can code the SQL as

SELECT foo, bar, baz from SomeTable
ORDER BY baz,foo, bar

In the designer, one adds the columns:
foo, bar, baz, foo, bar

then sets to ascending on the last three columns, and unchecks the
show: checkbox on the two rightmost columns.

Result: SQL equal to that created above from the designer.
 
Top