queries, sort by 2nd choice

V

viv

can only sort by 1 column how do i put in a 2nd choice eg
1st sort (postcode), 2nd sort (number of item in letter)
please help!
 
T

Tom Ellison

Dear Viv:

In the query design grid, the columns must sort left to right. If you
want to display ColumnA before ColumnB, but sort ColumnB before
ColumnA, put them in the grid so:

ColumnB don't display, sort
ColumnA display, sort
ColumnB display, don't sort

If you write SQL directly, just list them in the ORDER BY clause in
the order they sort.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Top