kongphui

Sort using custom order based on value list

Discussion created by kongphui on Jul 21, 2013
Latest reply on Jul 22, 2013 by jaysayers

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!

Outcomes