将列中的数字四舍五入 [英] Rounding UP numbers in a column

问题描述

大家好，


请帮我这个。


我想把我设计的专栏中的数字弄圆在一个查询中.....我唯一可以找到的函数是Ms.Access的圆形（）......它只能将数字上升到.5s


无论如何都要将数字四舍五入？

像1.1一样变成2

1.5轮到2也是.....


我可以用其他方法来计算数字吗？

基本上我想在可能的情况下将我的陈述插入查询。


非常感谢提前。

Hi all,

Please help me with this.

I''m trying to round up numbers in a column i designed within a query.....the only function I can find that Ms.Access has is the round()......which only rounds up numbers above .5s

Is there anyway to round UP the numbers?
Like 1.1 becomes 2
1.5 round up to 2 as well.....

Are there any other method I can use to round the numbers up?
Basically I''d like to slot my statement into the query if possible.

Thanks very much in advance.

推荐答案

大家好，


请帮我解决这个问题。


我正在尝试将我在查询中设计的列中的数字四舍五入.....我唯一能找到的功能Ms.Access是圆形的（）......它只能将数字加起来.5s


无论如何都要向上舍入n umbers？

喜欢1.1变成2

1.5回合2也是.....


还有其他吗？我可以用来舍入数字的方法吗？

基本上我想在可能的情况下将我的陈述插入查询中。


非常感谢预先。

Hi all,

Please help me with this.

I''m trying to round up numbers in a column i designed within a query.....the only function I can find that Ms.Access has is the round()......which only rounds up numbers above .5s

Is there anyway to round UP the numbers?
Like 1.1 becomes 2
1.5 round up to 2 as well.....

Are there any other method I can use to round the numbers up?
Basically I''d like to slot my statement into the query if possible.

Thanks very much in advance.

将实数UP舍入到下一个整数：

To round a Real Number UP to the next whole number:

展开 | 选择 | 换行 | 行号

Weeeee它的工作原理！


非常感谢！

Weeeee It works!

Thanks so much!

为了向上舍入 - 我通常加0.5然后使用CInt（）或CLng（）函数（ CLng（（计算）+0.5））。 Round（n，0）应该以类似的方式工作。为了向下舍入，我使用Int（）或Fix（），具体取决于ADezii的帖子（＃2）中详述的精确要求。

For rounding UP - I normally add 0.5 then use CInt() or CLng() functions (CLng((Calculation)+0.5)). Round(n,0) should work in a similar manner. To round down I use Int() or Fix() depending on the precise requirement as detailed in ADezii''s post (#2).

这篇关于将列中的数字四舍五入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！