Query Message: Scaling of Decimal Value resulted in data Truncatio

[DD]

This function works in Access 97 query but isn't working in 2003.
SumOfAmount Due: [GAIOD_VLX_IND_SALES_I4]![AMOUNT_DUE]/100, it's giving me a
message Scaling of Decimal Value resulted in data Truncation

 

[MGFoster]

This function works in Access 97 query but isn't working in 2003.
SumOfAmount Due: [GAIOD_VLX_IND_SALES_I4]![AMOUNT_DUE]/100, it's giving me a
message Scaling of Decimal Value resulted in data Truncation

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

Use a period (.) between table names and column (field) names, not an
exclamation point (!). Change the 100 to 100.0. If that doesn't work
try this:

CDbl([GAIOD_VLX_IND_SALES_I4].[AMOUNT_DUE]/100.0)

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

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

iQA/AwUBQm16G4echKqOuFEgEQLNYwCdFckcNepizOX3IvwUUlhQ74aBplEAoNmH
tPSH4kvxWcLunf44JYyzl+ub
=RLRH
-----END PGP SIGNATURE-----

 

[DD]

I tried what you said but it won't let me do 100.0. I entered an invalid
number. I put the () around everything and I still get the error message,
any other ideas???

This function works in Access 97 query but isn't working in 2003.
SumOfAmount Due: [GAIOD_VLX_IND_SALES_I4]![AMOUNT_DUE]/100, it's giving me a
message Scaling of Decimal Value resulted in data Truncation

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

Use a period (.) between table names and column (field) names, not an
exclamation point (!). Change the 100 to 100.0. If that doesn't work
try this:

CDbl([GAIOD_VLX_IND_SALES_I4].[AMOUNT_DUE]/100.0)

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

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

iQA/AwUBQm16G4echKqOuFEgEQLNYwCdFckcNepizOX3IvwUUlhQ74aBplEAoNmH
tPSH4kvxWcLunf44JYyzl+ub
=RLRH
-----END PGP SIGNATURE-----

 

[MGFoster]

You should be able to enter 100.0. There's something else going on.
Post the SQL view of the query.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

I tried what you said but it won't let me do 100.0. I entered an invalid
number. I put the () around everything and I still get the error message,
any other ideas???

:

This function works in Access 97 query but isn't working in 2003.
SumOfAmount Due: [GAIOD_VLX_IND_SALES_I4]![AMOUNT_DUE]/100, it's giving me a
message Scaling of Decimal Value resulted in data Truncation

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

Use a period (.) between table names and column (field) names, not an
exclamation point (!). Change the 100 to 100.0. If that doesn't work
try this:

CDbl([GAIOD_VLX_IND_SALES_I4].[AMOUNT_DUE]/100.0)

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

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

iQA/AwUBQm16G4echKqOuFEgEQLNYwCdFckcNepizOX3IvwUUlhQ74aBplEAoNmH
tPSH4kvxWcLunf44JYyzl+ub
=RLRH
-----END PGP SIGNATURE-----