Recent content by John B

I found the answer to the problem on another forum. Apparently, when adding two decimal numbers together created this problem. The official response from Microsoft is to use the CDbl function to create double number. This solution worked when I switched the query in Access from an expression...

Ok, I am getting the "Scaling of decimal value resulted in data truncation" which I know what it means but cannot figure out how to fix it. We upgraded are database from a 2000 version and the new version does not like the following query. I have isolated the problem to the crosstab row...

Working in Chicago, IL. I am an accountant but know enough programming to be dangerous :) Tech is more of my hobby than my occupation. John