V viv Mar 4, 2004 #1 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!
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 Mar 4, 2004 #2 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
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
