Query Message: Scaling of Decimal Value resulted in data Truncatio

G

Guest

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
 
M

MGFoster

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

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

Guest

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

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

-----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-----
Click to expand...
 
M

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

:

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scaling results in data truncation 2
SCALING OF DECIMAL VALUE RESULTED IN DATA TRUNCATION 3
scaling of decimal error with linked ODBC table 2
MICROSOFT JET ERROR 2
Scaling of decimal value resulted in data truncation 2
scaling of decimal value in data truncation 1
Access stripping decimal places in query 1
Scaling of decimal resulted in data truncation 2

Top