If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Invalid scale" error during Crosstab
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. |
#2
|
|||
|
|||
"Invalid scale" error during Crosstab
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" wrote in message ... 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. |
#3
|
|||
|
|||
"Invalid scale" error during Crosstab
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 "Michel Walsh" wrote: 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" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|