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:
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!