Hi! I would like to know is it is possible to customised sorting fields according to a criteria. Let me explain. I have a field called Ranks and the values are military ranks. Is it possible to do a sort from the highest to the lowest ranks and vice versa? Right now the sort options only sorts either by numbers/alphabetical order. However, for ranks say Lieutenant Commander and Lieutennant, the sort oder is wrong. Lieutenant Commander is obviously higher in rank than Lieutenant.

Anyone has any ideas?

Julian