This is two fields, ccode and namount, correct?

ccode is c(3)
namount is n(8.2) for this example

index would be

INDEX ON cCode + STR((-1)*nAmount,8,2) TO TAG MyTagName

Aloha,

James.

>how to index the following data (code ascending and amount descending)
>
>before:
>code amount
>---- ------
>AAA 100.00
>AAA 50.00
>BBB 200.00
>CCC 250.00
>AAA 300.00
>CCC 500.00
>BBB 100.00
>
>after:
>code amount
>---- ------
>AAA 300.00
>AAA 100.00
>AAA 50.00
>BBB 200.00
>BBB 100.00
>CCC 500.00
>CCC 250.00
>
>TQ.