Hi Everyone,

I want to index my table on two columns (item_code + item_date). I want to index in such way that,

Item_date is sorted in descending order and item code is sorted on ascending order.

E.g.
Item_code Item_date
========= =========
Item1 01/01/2003
Item2 01/01/2003
Item3 01/01/2003
Item1 01/04/2003
item2 01/04/2003
item3 01/04/2003

The above should be displayed as;
Item_code Item_date
========= =========
Item1 01/04/2003
Item2 01/04/2003
Item3 01/04/2003
Item1 01/01/2003
item2 01/01/2003
item3 01/01/2003

Any suggestions???

Cheers
Shaishav