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. OP
    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. OP
    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 ?
     
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page