Curious SORT fix
In my database I have a field which has several options in it's pull down menu:
(I'm not going to go into details about why this data is what it is)
I've automated the SORT so that it will sort by value list order.
Problem is, the file doesn't seem to recognize any difference between I, II, III and IV. If I change them to be 1, 2, 3, 4, the data sorts properly.
It's not that big a deal to have it be 1, 2, 3, 4, but I'm curious WHY the roman numerals wouldn't work. Any thoughts?