Field with Text & Number

[Sanj]

I have a table in Access with a field (with number in two
decimal) as a text.I went back in design and made it a
number. I lost the two digit numbers after decimal.I ran a
query the number did not addup correctly because of
rounding lost in converting text to number. Is there
anyway to retrieve number after decimal.Any help will be
highly appreciated
Sanj

 

[Rick Brandt]

I have a table in Access with a field (with number in two
decimal) as a text.I went back in design and made it a
number. I lost the two digit numbers after decimal.I ran a
query the number did not addup correctly because of
rounding lost in converting text to number. Is there
anyway to retrieve number after decimal.Any help will be
highly appreciated
Sanj

What kind of number did you change it to? If you had used Currency ,
Single, or Double, then the decimals should have been retained. If you
chose Integer or Long Integer (which don't have decimals) then the data was
truncated and discarded. This process should have prompted you that some
data loss could result and allow you to cancel the change.

You have a backup copy right?

 

[Luiz Cláudio]

Hi,

convert into a Number - Single type, instead of number - Long integer type.

[]
Luiz Cláudio C. V. Rocha
São Paulo - Brazil
MVP Office