Text to Long integer - digits after decimal lost

[italia]

I changed the Fieldsize Property from text to Long Integer and Decimal
Places = 6.

I had decimals in the original field. But after the transfer, the
digits after the decimals are gone.

Now even after I have change the Fieldsize propert to Decimal with
Scale = 2, the digits after the decimal are not seen.

For eg. If the text was 16.27. After I changed to long integer, it
changed to 16. Now when I convert to decimal it is still 16. The digits
after the decimal point are lost.

Does anyone know if there is a way I can get those digits back?

Thanks,
Ken

[Randy Harris]

"italia" <it*****@gmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

I changed the Fieldsize Property from text to Long Integer and Decimal
Places = 6.

I had decimals in the original field. But after the transfer, the
digits after the decimals are gone.

Now even after I have change the Fieldsize propert to Decimal with
Scale = 2, the digits after the decimal are not seen.

For eg. If the text was 16.27. After I changed to long integer, it
changed to 16. Now when I convert to decimal it is still 16. The digits
after the decimal point are lost.

Does anyone know if there is a way I can get those digits back?

Thanks,
Ken

I don't think there is any way to recover (other than from a backup). Long
Integers are integer values - ALL fractional values are discarded.

--
Randy Harris
(tech at promail dot com)

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

A Long Integer doesn't have decimal places; therefore, when you
converted the text to the Long the decimal places were dropped. Since
Long's don't have decimal places, when you change the Long to a Decimal,
there weren't any decimal places to convert to the Decimal.

Instead of

String -> Long -> Decimal

Do

String -> Decimal

This should preserve you decimal places.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQji+GYechKqOuFEgEQKzSwCgg5bUNcx9XRYU1tCW69gfPp 41y84AnjPS
OKOUx0EhCjsGFqJZk5lFhfTx
=SvTQ
-----END PGP SIGNATURE-----
italia wrote:

I changed the Fieldsize Property from text to Long Integer and Decimal
Places = 6.

I had decimals in the original field. But after the transfer, the
digits after the decimals are gone.

Now even after I have change the Fieldsize propert to Decimal with
Scale = 2, the digits after the decimal are not seen.

For eg. If the text was 16.27. After I changed to long integer, it
changed to 16. Now when I convert to decimal it is still 16. The digits
after the decimal point are lost.

Does anyone know if there is a way I can get those digits back?

Thanks,
Ken

[italia]

Good lesson learned.
If I choose Long Integer as the field size in the design view, it gives
me an option for decimal places. What would be this for? This got me
confused.

[Rick Brandt]

italia wrote:

Good lesson learned.
If I choose Long Integer as the field size in the design view, it
gives me an option for decimal places. What would be this for? This
got me confused.

MS stupidity. Every other database designates all of the numerical types as
TYPES. In Access MS decided to lump them all in the type "Number" and use the
field length to distinguish them. You're absolutely correct that it is
confusing.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com