Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    May 2008
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    removing decimal point (access 2003)

    How do I remove decimal point in an access data column when the column is set as a text? For example, in the data column, value are: 289.53, 53.1, 48.03, V256.3, V256.01, 253, ect... I want to create a new data column to display the following from my example: 28953, 531, 4803, V2563, V25601, 253, ect... Please assist.

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

    Re: removing decimal point (access 2003)

    If you want this in a different column, you don't need to store it in the table, you can calculate it on the fly in a query. Create a query based on the table, add the fields you need, plus a calculated field:
    <code>
    NewField: Replace([OldField],".","")
    </code>
    where OldField is the name of the original field, and NewField is the name you want to give the calculated field.

  3. #3
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: removing decimal point (access 2003)

    Hi Hans,

    How about if there's some data in "OldField?" How can I add condition to this calculated field to convert those blank data to "00?"

    Thanks,

    Regards,

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

    Re: removing decimal point (access 2003)

    Did you mean How about if there's NO data in "OldField?"

Posting Permissions

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