Field with Text & Number

  • Thread starter Thread starter Sanj
  • Start date Start date
S

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
 
Sanj said:
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
Click to expand...

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?
 
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
 
Back
Top