Scaling of decimal resulted in data truncation

[Christina Gonzalez]

I created a query call qryProcessBOMSummary that contains
a this field Cost:[Total_Sec]*[Plant_Labor_Rate]. I
created a subform called ProcessBOM subform based on this
query. I have a main form called RFQ Summary that
contains this ProcessBOM subform. On the main form I
created a command button that contains code command that
DSum the Cost column on the subform. I recieve this
error Scaling of decimal resulted in data truncation. On
my query qryProcessBOMSummary I have checked my
formatting to be like 0.0000 and in my code i declared
this a single and checked my rounding and i am still
recieving this error. Does anyone have an idea what i
could do to resolve this..?

 

[Larry]

-----Original Message-----
I created a query call qryProcessBOMSummary that contains
a this field Cost:[Total_Sec]*[Plant_Labor_Rate]. I
created a subform called ProcessBOM subform based on this
query. I have a main form called RFQ Summary that
contains this ProcessBOM subform. On the main form I
created a command button that contains code command that
DSum the Cost column on the subform. I recieve this
error Scaling of decimal resulted in data truncation. On
my query qryProcessBOMSummary I have checked my
formatting to be like 0.0000 and in my code i declared
this a single and checked my rounding and i am still
recieving this error. Does anyone have an idea what i
could do to resolve this..?
.
Try this

Cost:round([Total_Sec]*[Plant_Labor_Rate],4)
change your formatting to general decimals to 4

 

[Christina G.]

Thank you!