Scaling of decimal resulted in data truncation

  • Thread starter Thread starter Christina Gonzalez
  • Start date Start date
C

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..?
 
-----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
Click to expand...
Cost:round([Total_Sec]*[Plant_Labor_Rate],4)
change your formatting to general decimals to 4
 
Back
Top