I am having data type problems.
The first thing I had to do was convert the weight of one column from kg to lb. I did this by multiplying by 2.20462262 and updating a new column, however, the column with the weight in kg was of the number data type but the new column with the weight in lb was of the text data type! It needs to be in number type, not text. Why is this and what can I do to change it?
I have also tried to convert various columns into different data types and it claims that there is not enough memory or disk space. There was a column of text type with 255 characters and I tried to shorten it to 10, and it threw that error. My only success was converting numbers to text, but that is the opposite of what I need.
Lastly, I need to change the number of decimal places the number column goes to, but every time I change it in the design view and save it, the numbers are unaffected. Why is this?
Thank you in advance for any help you can give me.
The first thing I had to do was convert the weight of one column from kg to lb. I did this by multiplying by 2.20462262 and updating a new column, however, the column with the weight in kg was of the number data type but the new column with the weight in lb was of the text data type! It needs to be in number type, not text. Why is this and what can I do to change it?
I have also tried to convert various columns into different data types and it claims that there is not enough memory or disk space. There was a column of text type with 255 characters and I tried to shorten it to 10, and it threw that error. My only success was converting numbers to text, but that is the opposite of what I need.
Lastly, I need to change the number of decimal places the number column goes to, but every time I change it in the design view and save it, the numbers are unaffected. Why is this?
Thank you in advance for any help you can give me.
Comment