Welcome to SPN

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

Sign Up Now!

how do I remove 0's from in front of a number. 00012 to 12

Discussion in 'Information Technology' started by PWK, Nov 16, 2005.

  1. PWK

    PWK
    Expand Collapse
    Guest

    I have a data base thet has a list of numbers of

    zipcode city # of persons

    75204 Dallas 00284
    64784 xxxxxx 00023

    how do I remove the 00's in the third row ?
     
  2. Loading...


  3. Rick B

    Rick B
    Expand Collapse
    Guest

    Where? In a form? Report? Query?

    What kind of field is it? If it is a numeric field, then it should not show
    leading zeros. It sounds like you have your field defined as a text field.
    Change it to a number.

    --
    Rick B



    "PWK" <PWK@discussions.microsoft.com> wrote in message
    news:BEA49243-8CC1-414B-87BC-86FE661248E6@microsoft.com...
    >I have a data base thet has a list of numbers of
    >
    > zipcode city # of persons
    >
    > 75204 Dallas 00284
    > 64784 xxxxxx 00023
    >
    > how do I remove the 00's in the third row ?
     
  4. Ofer

    Ofer
    Expand Collapse
    Guest

    Use the val to return the number without the 00

    =Val(FieldName)

    or

    Select Val(FieldName) As NewNumber From TableName


    --
    I hope that helped
    Good Luck


    "PWK" wrote:

    > I have a data base thet has a list of numbers of
    >
    > zipcode city # of persons
    >
    > 75204 Dallas 00284
    > 64784 xxxxxx 00023
    >
    > how do I remove the 00's in the third row ?
     

Share This Page