访问问题 [英] Access Problem

问题描述

任何人都可以帮助我尝试使用表达式构建器创建一个表达式，当公式尝试除以零时返回零。

到目前为止，我的尝试都失败了。

这是我到目前为止所尝试过的。我觉得我的逻辑是正确的，也许我的语法是关闭的。

Expr1：IIf（Bsheetcostdraft！[CSA / SAA] = 0,0，Icostcostdraft！[CSA / SAA] / Bsheetcostdraft！[CSA / SAA]）

任何人都可以引导我完成这个。

Can anyone Help I am trying to use the expression builder to create an expression that returns a zero when a formula tries to divide by zero.
So far my attempts have failed.
This is what I have tried so far. I feel my logic is correct maybe my syntax is off.
Expr1: IIf(Bsheetcostdraft![CSA/SAA]=0,0,Icostcostdraft![CSA/SAA]/Bsheetcostdraft![CSA/SAA])
Can anyone guide me through this.

推荐答案

你试过''。''而不是''！''？另外我觉得你用lcostcostdraft打错了，应该是lsheetcostdraft？

Have you tried ''.'' instead of ''!''? Also I think you made a typo with lcostcostdraft, should probably be lsheetcostdraft?

你试过''。''而不是'' ！ ''？另外我觉得你用lcostcostdraft打错了，应该是lsheetcostdraft吗？

Have you tried ''.'' instead of ''!''? Also I think you made a typo with lcostcostdraft, should probably be lsheetcostdraft?

我尝试切换！对于。无济于事，我知道我的命名惯例似乎很奇怪，但它们是正确的。我真的被困在这里。你甚至可以在选择查询的空格标记字段中放置这样的表达式。

I did try switching the "!" for "." To no avail and I know my naming conventions seem wierd but they are correct. I really stranded here. Can you even put an expression like this in the space marked field for a select query.

是的，你可以这样做。带''/'的字段怎么样？您是否尝试从字段名称中删除这些字符？这可能会影响您的其他查询。

Yes, you can do this. What about the fields with ''/'' Have you tried removing those characters from the field name? This may impact other queries you have.

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