>>>Maybe you can add a sign flag to the string with iif(x<0,'A','B') or something like that. Then negative values are lower then positive ones.
>>
>>This puts the negative numbers first, but the higher negative numbers are listed first.
>
>Oops,
>
>of course,
>
>I then think you may use the method of George (Message #
499752)
>(Not tested that)
Ko,
I should work as long as the result of the multiplication is in the range between –2,147,483,648 to 2,147,483,647. So if the total field size is less than 10 it should work.
George
Ubi caritas et amor, deus ibi est