DD said:
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-----