AnsweredAssumed Answered

Sorting Numbers is Ascending Order

Question asked by ghester on May 8, 2012
Latest reply on Apr 18, 2013 by BruceHerbach

I have attached a report our software developer created for us in FM Pro Advanced 11. This report, along with everything else we do in FM is sorting by the first number only. ie: 1,10, 100, 2, 20, 200, 3, 30, 300... rather than sorting the numbers lowest to highest. ie: 1, 2, 3, 4.....and so on. Our developers says this is the only way we can report these fields however this blows my mind that a system wouldnt have the smarts to sort numbers correctly. I have no IDEA have to create software in this database so I need some VERY Elementary help in this area.