Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Sort number is lookup

Discussion in 'Information Technology' started by Kelly, Jul 28, 2006.

  1. Kelly

    Kelly
    Expand Collapse
    Guest

    I am creating a table with a lookup colum...in the lookup colum I refer to
    another table for the data...
    the problem is the number sort...it sorts as 1, 11, 12,....2, 20 etc....
    How do I sort the lookup column to sort as 1, 2, 3, .....10, 11, 12 etc...????
    --
    Kelly
     
  2. Loading...

    Similar Threads Forum Date
    I am sort of new to Sikhism New to Sikhism May 3, 2013
    Consortium agrees to pay 11.3 billion dollars for SunGard Data Systems (AFP) Interfaith Dialogues Mar 28, 2005
    Shabad Numbering System New to Sikhism Dec 1, 2015
    USA A Heart Attack And The Numbers Breaking News Aug 2, 2014
    Pacific Borneo: Sikhs small in number, strong in presence Breaking News Nov 11, 2013

  3. Rick B

    Rick B
    Expand Collapse
    Guest

    Looks like you are using a TEXT field, not a number field.

    --
    Rick B



    "Kelly" <Kelly@discussions.microsoft.com> wrote in message
    news:D0D25DE5-4996-44F9-9B79-CE4472B6340D@microsoft.com...
    >I am creating a table with a lookup colum...in the lookup colum I refer to
    > another table for the data...
    > the problem is the number sort...it sorts as 1, 11, 12,....2, 20 etc....
    > How do I sort the lookup column to sort as 1, 2, 3, .....10, 11, 12
    > etc...????
    > --
    > Kelly
     
  4. Tom Ellison

    Tom Ellison
    Expand Collapse
    Guest

    Dear Kelly:

    A number will sort 1, 2, 3, . . .

    Text will sort 1, 11, 12, . . .

    So, if you want it to sort as a number, make it a number.

    Tom Ellison


    "Kelly" <Kelly@discussions.microsoft.com> wrote in message
    news:D0D25DE5-4996-44F9-9B79-CE4472B6340D@microsoft.com...
    >I am creating a table with a lookup colum...in the lookup colum I refer to
    > another table for the data...
    > the problem is the number sort...it sorts as 1, 11, 12,....2, 20 etc....
    > How do I sort the lookup column to sort as 1, 2, 3, .....10, 11, 12
    > etc...????
    > --
    > Kelly
     
  5. Kelly

    Kelly
    Expand Collapse
    Guest

    I figured it out...I forgot to mention that I need to keep it as a text field
    so I changed the numbers from 1, 2, 3, to 01, 02, 03,...it now sorts perfectly
    --
    Kelly


    "Rick B" wrote:

    > Looks like you are using a TEXT field, not a number field.
    >
    > --
    > Rick B
    >
    >
    >
    > "Kelly" <Kelly@discussions.microsoft.com> wrote in message
    > news:D0D25DE5-4996-44F9-9B79-CE4472B6340D@microsoft.com...
    > >I am creating a table with a lookup colum...in the lookup colum I refer to
    > > another table for the data...
    > > the problem is the number sort...it sorts as 1, 11, 12,....2, 20 etc....
    > > How do I sort the lookup column to sort as 1, 2, 3, .....10, 11, 12
    > > etc...????
    > > --
    > > Kelly

    >
    >
    >
     

Share This Page