Announcement

Collapse
No announcement yet.

sorting people results

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    sorting people results

    I am trying to sort by number, que columns called "identificação" - but instead os going from 1,2, 3 and so on - it goes from 1 to 10 to 100, to 1000 , 1001...
    Can anyone tell me what I am doing wrong?
    Attached Files

    #2
    Reunion is doing an alphabetical sort not a numeric sort.

    You would need to add leading '0's to get this list to sort numerically. For example change "Site 1 ok" to "Site 0001 ok" and "Site 102 ok" to "Site 0102 ok"

    I realize this is probably not an reasonable option, that is just the nature of an alphabetical sort.
    Gregg Witmer
    Leister Productions, Inc.

    Comment


      #3
      It's counterintuitive, but that's a text column that's being sorted alphabetically. As an example, "Site 101 ok" comes after "Site 1009 ok" because when sorting by text, "101[space]" comes after "1009". It's like "bab" would come after "baai".

      Edit: What Gregg said.
      Tim Lundin
      Heartland Family Graphics
      http://www.familygraphics.com

      Comment

      Working...
      X