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 ?
/Torgny