Sort By ID and then Year

  • Thread starter Thread starter Ling
  • Start date Start date
L

Ling

This is a small problem but I just cant seem to figure it
out. I have a query that shows the results below:

No Year
---- ------
1 2003
1 2004
2 2003
2 2004
etc...

Now I would like it to sort by the no first and then by
year so the end result shld be something like this(when
the latest year on top):

No Year
---- ------
1 2004
2 2004
1 2003
2 2003
etc...

This is simple but I just cant get the results I want.
Any ideas?
Thanx

Ling
 
You are sorting by the number first. What you have in your example of what
you want would be sorting by the year first in descending order then by the
number. The items are sorted as they appear in the query grid from left to
right. To sort on the other item first, you will need to select then drag
that column to the left of the other column.
 
Back
Top