>>>I would like for the positive numbers to list on top so as to go from higher to lower. Is there a way around that/this?
>>>
>>Add an extra field, ..., abs(fieldxy) as absval, ... order by absval descending
>>
>>You don't need to show that extra field anywhere, just use it for ordering.
>
>I've never used local views, and in TSQL you can't use ORDER BY in a view, however would ORDER BY ABS(fieldxy) DESCENDING work?
Um... a view? Haven't used that since... dunno, 2008 or 2004, and even then it was inherited stuff. Why'd anyone use views when we have SPT or cursoradaptors.
So yeah, I automatically translated this as being a SQL question. The word „view“ fell right on my blind spot :)