#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2013
    Posts
    42
    Rep Power
    2

    Switching to number from text


    Hi!
    I was wondering if anyone has a solution for this access problem.
    After importing another database to access the numbers enters as a text value. When I try to switch the value into a numer the value changes. It becomes a totally different value that is a lot larger.

    I want to change it so that I can use it with math expressions..
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2013
    Posts
    42
    Rep Power
    2
    Originally Posted by ChristopherL
    Hi!
    I was wondering if anyone has a solution for this access problem.
    After importing another database to access the numbers enters as a text value. When I try to switch the value into a numer the value changes. It becomes a totally different value that is a lot larger.

    I want to change it so that I can use it with math expressions..
    Solved it!

    Swedish settings so Access didnt notice "." as a decimal!

IMN logo majestic logo threadwatch logo seochat tools logo