6 Replies Latest reply on Jul 22, 2013 10:53 PM by jaysayers

    Sort using custom order based on value list

    kongphui

      I am working on a student databse, and need to sort their school levels from pre-kindergarten onwards.

       

      I am trying to sort using custom order based on this value list:

      PK3

      PK2

      PK1

      K

      1

      2

      3

      4

      5

      6

       

      However, the sort result returned is not similiar to my requested order.  K is always sorted as the last.

       

      I am wondering if anybody has faced similar issue, and figured out some workarounds.  Thanks!