代码限制精度？

问题描述

大约一个星期前有人发布过相同内容，但是我找不到它。


有人会提出几行代码来确保

Double的存储时间不超过八位小数值

精度？


VBA或SQL ....我'' 猜的逻辑是相同的

解决方案

我正在做的事情：


UPDATE SET tblReturnMonthly = tblReturnMonthly.ReturnRate

CDbl（格式

Somebody posted same about a week ago, but I''m unable to find it.

Could somebody put up a few lines of code that would ensure that a
Double is stored with no more than, say, eight decimal places worth of
precision?

VBA or SQL....I''m guessing the logic is the same.

解决方案

I''m currently doing:

UPDATE tblReturnMonthly SET tblReturnMonthly.ReturnRate =
CDbl(Format

这篇关于代码限制精度？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！