"Invalid scale" error during Crosstab

[Bruce Meneghin]

I received the error "Invalid scale for decimal data type" while trying to
execute this crosstab query (created with crosstab wizard)

TRANSFORM Sum(INV_ages.Acres) AS SumOfAcres
SELECT INV_ages.period, Sum(INV_ages.Acres) AS [Total Of Acres]
FROM INV_ages
GROUP BY INV_ages.period
PIVOT INV_ages.Age;

INV_ages is a query. I will spare you its SQL for now.

Any clue what might be causing this strange error. I have executed this
query successfully in the past.

 

[Michel Walsh]

Is it possible the SUM generates a value larger than what the given scale
allowed? (You are using decimal data type, not floating point type, yes? )


Vanderghast, Access MVP

 

[Bruce Meneghin]

I don't think so. I was able to end-run the problem by changing the source
query to a make-table query and then doing a crosstab on the table. Thanks
for the thought.
Bruce

Is it possible the SUM generates a value larger than what the given scale
allowed? (You are using decimal data type, not floating point type, yes? )


Vanderghast, Access MVP

I received the error "Invalid scale for decimal data type" while trying to
execute this crosstab query (created with crosstab wizard)

TRANSFORM Sum(INV_ages.Acres) AS SumOfAcres
SELECT INV_ages.period, Sum(INV_ages.Acres) AS [Total Of Acres]
FROM INV_ages
GROUP BY INV_ages.period
PIVOT INV_ages.Age;

INV_ages is a query. I will spare you its SQL for now.

Any clue what might be causing this strange error. I have executed this
query successfully in the past.