计算销售税的四舍五入问题 [英] Rounding Problems Calculating Sales Tax

问题描述

我在查询中计算销售税。我需要征收销售税，但我已经尝试了我在互联网和这个论坛上找到的所有东西，但我无法得到任何工作。这是我想要做的：

展开 | 选择 | Wrap | 行号

解决方案

（16.4 KB，306 views）

我通过写Round（0.055,2）测试了它，得到了0.06然后加了Ccur（Round（0.55,2）并且仍然得到0.06

I am calculating Sales Tax in a query. I need the sales tax to round up, but I''ve tried everything I''ve found on the internet and in this forum and I can''t get anything to work. Here is what I am trying to do:

Expand|Select|Wrap|Line Numbers

解决方案

@loonette
Not really sure what to say here. I tested it in Access and it rounds 0.055 up to 0.06. Why you would be getting a different result is beyond me.

Which formula did you try? Was it the first or second? Because the first rounds up to .06, the second rounds down to point .055. Below you can see what is going on on my form, it is calculating .605 and giving me a remainder of .01- when calculating the balance. Thanks!

Attached Images

form.jpg (16.4 KB, 306 views)

Well I tested it by writing Round(0.055,2) and got 0.06 then added Ccur(Round(0.55,2) and still got 0.06

这篇关于计算销售税的四舍五入问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！