I've created a a report which includes a "Rank" Field in each record. I want to list my records according to the "Rank" field in the order 1, 2, 3 ..... 1900 etc. I've spent hours on this and whilst I've found a solution... it isn't simple or elegant.... Just wondering if anyone else would have a better idea....
The records are ranked by a number between 1 and 1900. When I introduce a "Sort" function, I only get options to sort A-Z and Z-A (with the criteria for the sort being the first characters in the string.)
Even when I select "Sort by Entire Value" rather than the "First Character" or "First & Second Character" it is looking at alpha strings reading from left to right and not the entire Numeric string. Therefore... for example... 125 is listed before 35.... and 567 is listed before 98.
In order to make this sort numerically, it seems that I have to add leading Zeros to my rank numbers (e.g. 0001, 0034, 0125) so that the sort fuction reads the "entire value" This means that I've got to go through 999 records and put leading zeros ahead of the number....
Is there a better way to do this?
Long suffering Jimbo !