Alpha Video Training
Results 1 to 5 of 5

Thread: Column Sort on List Box

  1. #1
    Member njguy's Avatar
    Real Name
    Tom Ritter
    Join Date
    Nov 2009
    Location
    New Jersey
    Posts
    289

    Default Column Sort on List Box

    Capture.JPG

    Has anyone had an issue sorting columns in a list box and not getting the correct results?

    See attached image

    Thanks

  2. #2
    "Certified" Alphaholic Clipper87's Avatar
    Real Name
    Frank
    Join Date
    Dec 2008
    Location
    Antwerp, Belgium
    Posts
    1,891

    Default Re: Column Sort on List Box

    Looks like you're dealing with strings and in that case the sort is correct
    Frank

    Tell me and I'll forget; show me and I may remember; involve me and I'll understand

  3. #3
    Member njguy's Avatar
    Real Name
    Tom Ritter
    Join Date
    Nov 2009
    Location
    New Jersey
    Posts
    289

    Default Re: Column Sort on List Box

    But if I use the transform to number option I lose the format that was defined.

  4. #4
    "Certified" Alphaholic Clipper87's Avatar
    Real Name
    Frank
    Join Date
    Dec 2008
    Location
    Antwerp, Belgium
    Posts
    1,891

    Default Re: Column Sort on List Box

    Leading zeroes?
    Frank

    Tell me and I'll forget; show me and I may remember; involve me and I'll understand

  5. #5
    Member
    Real Name
    Jim Brown
    Join Date
    Jun 2000
    Location
    Wellington, FL
    Posts
    117

    Default Re: Column Sort on List Box

    Create in the query a second column for the same data that is numeric in value. Then select it under Sort Column for this string field in List layout.

Similar Threads

  1. Replies: 1
    Last Post: 10-04-2013, 08:09 AM
  2. multiple column sort
    By artjen@comcast.net in forum Alpha Five Version 7
    Replies: 1
    Last Post: 09-23-2010, 11:05 PM
  3. Sort on a Column
    By lerg in forum Alpha Five Version 8
    Replies: 2
    Last Post: 12-17-2007, 11:21 PM
  4. Remain on Row after Column Sort
    By csda1 in forum Archived Wishlist
    Replies: 5
    Last Post: 11-10-2007, 10:26 AM
  5. New Quick Sort Column click & moving column
    By dchiass in forum Alpha Five Version 8
    Replies: 0
    Last Post: 05-28-2007, 08:07 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •