Access Round Round女士 [英] Ms Access Round Up

问题描述

我需要在Access中创建一个Roundup函数，例如.....


36.11到36.2

44.43到44.5
$ b $ 55.55至55.6

32.51至32.6

21.67至21.7


PS：我是写作的业余爱好者VBA代码和创建模块Access

I need to create a Roundup function in Access for example.....

36.11 to 36.2
44.43 to 44.5
55.55 to 55.6
32.51 to 32.6
21.67 to 21.7

PS: I''m an amateur at writing VBA code and creating modules within Access

推荐答案

Hi Te，


欢迎来到脚本！


您无意中在我们的文章部分发布了您的问题。我已经把它移到我们的主论坛，在那里它更有可能得到回复。


MODERATOR

Hi Te,

Welcome to the Scripts!

You have inadvertently posted your question in our Articles section. I have moved it across for you to our main forum where it is much more likely to get a response.

MODERATOR

正常的功能VBA / Access提供称为Round（），但它不会按照你的要求进行，因为它会舍入到最接近的小数位，而不是下一个最高小数位。


这是在这种情况下，你必须写一个Select Case函数来做你想要的。


这应该这样做：

The normal function that VBA/Access provides is called Round(), however it will not do what you are asking, since it rounds to the nearest decimal place, not the next highest decimal place.

This being the case, you''ll have to write a Select Case function to do what you are asking.

This should do it:

展开 | 选择 | Wrap | 行号

我需要在Access中创建一个Roundup函数，例如.....


36.11到36.2

44.43至44.5

55.55至55.6

32.51至32.6

21.67至21.7


PS：我是一名业余爱好者，在写入VBA代码并在Access
中创建模块

I need to create a Roundup function in Access for example.....

36.11 to 36.2
44.43 to 44.5
55.55 to 55.6
32.51 to 32.6
21.67 to 21.7

PS: I''m an amateur at writing VBA code and creating modules within Access

Kuini。

Hi, Kuini.

展开 | 选择 | Wrap | 行号

这篇关于Access Round Round女士的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！