Forum Discussion
Sequential serial numbers do not come up in sequence
I have a number of areas for whom I raise Penalty Notices, and want them to show in sequntial order. When i trip over 9 into 10, it then sequences after the #1 number, and not after the #9 ...
Phil_Gibbs That's because you are sorting texts. "FORW11" comes before "FORW2".
I you want the text sorting to be correct, change the codes so that the have the same number of numbers at the end using leading zeroes. Then "FORW002" will sort before "FORW011".