Can anyone help me with the right syntax for an indexkey that sort the following data:


cAuktCID cObjectCID nOffer CID
" 21" " 83" 567.00 " 129"
" 21" " 83" 567.00 " 126"
" 21" " 83" 567.00 " 128"
" 21" " 83" 650.00 " 125"


I want it to look like this when it's indexed.

Desc Desc Desc Asce
" 21" " 83" 650.00 " 125"
" 21" " 83" 567.00 " 126"
" 21" " 83" 567.00 " 128"
" 21" " 83" 567.00 " 129"

I have tried with this, but i does not work:
cAuktCID + cObjectCID + STR(nOffer) + STR(VAL(cid)*-1) DESCENDING

The 3 first columns gets sorted right but CID-column always
ends up in descending order although i use -1 in the calculation.
What am i missing here ?