var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Sort Ascending - with nulls at the bottom?
Is it possible to sort ascending but have the null values at the bottom instead of the top of the list?
Thanks in advance.
you could create a query that generates a new sort field:
myFirstSortKey: iif([myField] is Null,1,0)
Then sort by myFirstSortKey then by myField in your query
Sweet! That works nicely... I originally had SortOrder: [fieldName] is null but it didn't like the syntax due to the odbc connection.
Originally Posted by howey
Thanks heaps for that!!!