Truncated text

[Arslan]

I have a table created from a text file, almost all of the fields are
imported as text and some fields need to be converted to numbers. When
I change the date type of the field in the table from "text" to
"number", the decimals get truncated. I tried to create a dummy field
with "number" as the data type and populated it with an update query
but still lost the decimals even after using the format function.
What am I missing? Is there a way to get around this and capture the
decimals in number format?
Thanks.

 

[Rick B]

You are probably putting this in an INTEGER field. INTEGERS (by definition)
are whole numbers without decimal places. Make it a different numeric type
(single/double/etc.)

 

[Arslan]

Thank you, I can't believe I missed that......