Decimal Places - rounding

Question

Hello,I can't seem to figure out why my query is rounding decimal places.&nbsp; I'll attach some screenshots.&nbsp; I must not have the settings proper.&nbsp; The form is calculating to 2 decimal places just fine.But the query that writes those calculations to the table is rounding for some reasonIs Standard, 2, not what I should have it set at?&nbsp;Appreciate any help&nbsp;&nbsp;

george_hepworth · Answer

Elaine180&nbsp;&nbsp;First, it is generally undesirable to save calculated values to a table in the first place, so you might need to rethink why this should be done at all. Whenever you have component values for a calculation stored as individual fields, that is adequate to recalculate the other value as needed, where needed. In a report for example.&nbsp;That said, you probably have a different datatype defined for the field in the table. What is it?

elaine180 · Answer

George_Hepworth&nbsp;&nbsp;Thank you.&nbsp;I thought I would need to write those values to the table so that I could use them later in calculations for reports.... no?&nbsp; For example, if I'd like to know how many acres planted between a date range.Either way, this is the plantings table, I set them to Double, Standard, 2.&nbsp; Is that not correct?&nbsp;

elaine180 · Answer

Also, I will try generating a report now where I calculate the Acres Planted right in the report and not use the number from the table (hopefully it won't round).

george_hepworth · Answer

Elaine180&nbsp;&nbsp;Well, you can store and re-use the calculated values. However, the same formula which calculates them in this query can also be used anywhere else you need to re-calculate the value. This is in line with good relational database design practice.&nbsp;The reason we avoid storing calculated values is that hard-codes it into a field. If one of the components later gets changed, perhaps due to a correction for a data entry error, that calculated value becomes invalid and that's a bad thing.&nbsp;Sometimes, we DO store a calculated value because we want to retain the "As Of This Date Calculated Value", knowing that a future calculation may be different because of changed conditions. A selling price as of the date of sale is an example of this case. Prices go up all the time, so we store the calculated price as of the date of sale so future reports accurately that As Of price for the date of the sale.&nbsp;Here, there should be no such adjustments except when you correct a value entered incorrectly.&nbsp;&nbsp;Now, the reason for the loss of decimals could be in the calculation. Can you post the ACTUAL expression, not just a screen shot?&nbsp;Thanks.

george_hepworth · Answer

It would be helpful to see the calculation. It might expose something a screen shot can't.

Forum Discussion

Decimal Places - rounding

Share

Resources