-----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