Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    81

    Question 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.

  2. #2
    Join Date
    Jul 2004
    Location
    Southampton, UK
    Posts
    368
    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

    hth
    Chris

  3. #3
    Join Date
    Oct 2003
    Posts
    81

    Talking

    Quote Originally Posted by howey
    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

    hth
    Chris
    Sweet! That works nicely... I originally had SortOrder: [fieldName] is null but it didn't like the syntax due to the odbc connection.

    Thanks heaps for that!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •