Sorting a alphabetic field in non alphabetic order

[HeatherK21]

I have a priority field of High, Medium, Low. I want to sort these in ascending order, but not by name, but by value. High, Medium and Low rather than High, Low, Medium. I am pretty new at this so please bare with me. Any help I can get will be greatly appreciated.

 

[Impart]

You could use letters A B C to represent High Medium Low, that seems simple enough but if you want the words then aHigh etc. would work

 

[Impart]

PS
1,2,3 or 1st 2nd 3rd
seems better still

 

[suesloan]

Create a calculated field to sort on:

SortP = If(priority = 'High',1,If(priority = 'Medium',2,3))

Sue Sloan
XpertSS.com