如果功能有问题 [英] If function problem

问题描述

大家好，我的一个代码遇到了一些问题。我正在创建一个数据库，其中一个人可以勾选框并从现有的120中选择60个信用额。但不知何故，我的if函数不计算总数...最后我收到消息请选择每学期30学分


我将不胜感激！谢谢:)

Hello everyone, I got some problems with one of my codes. I am making a database where a person can tick boxes and chose 60credits from existing 120. But somehow my if function does not calculate the total..and at the end I get Message "Please chose 30credits per semester"

I would appreciate some help! Thank you :)

展开 | 选择 | Wrap | 行号

推荐答案

Jar！

从我的练习中我可以说IF之后有更多的条件=更麻烦。

当然，完全熟练的程序员可以很好地处理。但只有他们。

我的建议是使用括号，以便向VBA说出你想要的。例如：

相反：

Jar !
From my practice I can say that more conditions after IF = more troubles.
Of course, the full skilled coders can handle that very well. But only they.
My advice is to use parenthesis in order to say to VBA exactly what you wish. As example:

Instead:

展开 | 选择 | Wrap | 行号

亲爱的Mihail，


感谢您的时间，但您的解决方案无法解决我的问题。我尝试在if语句中使用括号，但仍然不计算变量..


Jaroslav;（

Dear Mihail,

Thank for your time, but your solution does not solve my problem. I tried to use brackets in my if statements and it still does not calculate the variables..

Jaroslav ;(

好吧，让'''从基础开始，然后将您送到大本营（发布时（VBA或SQL）代码）当我们有一个正确的问题时，我们可以考虑为你看一下。

Well, let''s start with the basics and send you to base-camp (When Posting (VBA or SQL) Code) first. When we have a proper question we can think about looking at it for you.

这篇关于如果功能有问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！