Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Data not sorting correctly (2000)

    I am having problems trying to sort out data in a table in ascending order.
    I have tried to do this but the data is not sorting right, any ideas as to how l can rsolve this issue?

    If you see the drop down also in the attachment you will see the problem l am having with trying to sort the data.
    Also in the attachment is a sorted table list , which needs to be sorted correctly.

    see attachment.

    justin.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Data not sorting correctly (2000)

    The 'numbers' in the table are left-aligned. This indicates that the field is a text field, and hence sorting will be in alphanumeric order, not in numeric order. Is it possible to change the field to a number field, or does it also contain 'numbers' with alphabetic characters?

  3. #3
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Data not sorting correctly (2000)

    Thanks for your help, l changed to table value to numeric and it now works fine.

    Justin

Posting Permissions

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