>>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?
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.