Truncated text

  • Thread starter Thread starter Arslan
  • Start date Start date
A

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.
 
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.)
 
Back
Top