Results 1 to 4 of 4

Thread: sorting numbers

  1. #1
    Join Date
    Jun 2002
    Posts
    19

    Unanswered: sorting numbers

    Hi, just wondering if anyone's got any good solutions for sorting numbers in which 03 (meaning year) when sorted descending is greater than 99.
    As of now it sorts say from 99 down to 90 then switches to the year '03 to '00. How annoying.

  2. #2
    Join Date
    Oct 2002
    Location
    NSW Australia
    Posts
    61
    Just format your numbers as yyyy format

    format([MyNumber],"yyyy")

    HTH :0)

  3. #3
    Join Date
    Jun 2002
    Posts
    19
    Sorry, didn't make it clear that it is actually not a year but a number that begins w/ the last two digits of the year.

  4. #4
    Join Date
    Oct 2002
    Location
    NSW Australia
    Posts
    61
    No, You were clear. If you create a column in your record source with the function:

    format([MyNumber],"yyyy")

    and sort by this column you will have no problems.

Posting Permissions

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