如何使Nz（）函数返回Currency值？ [英] How do I make an Nz() function return a Currency value?

问题描述

我有一份报告，我用它作为发票向我们的客户收费。有些指控是空白的。我希望能够拥有它，如果值为空，则将 $ 0.00 。我尝试使用Nz（）函数（ Nz（PerEntryCharge，0），但只返回 0 ，即使报表中控件的格式设置为currency。我尝试在Nz（）函数中嵌套CCur（）函数，如下所示： Nz（PerEntryCharge，CCur（0）），但仍然返回 0 。我不知道我不知道还有什么可以尝试。


我相信我之前遇到过类似的问题，但我不记得哪个数据库所以我可以找到我用过的东西。

I have a report that I use as an invoice to charge our customers. Some of the charges are blank. I would like to be able to have it so that if the value is blank, it would put $0.00. I tried using the Nz() function (Nz(PerEntryCharge, 0), but that just returns 0 even though the format for the control in the report is set to currency. I tried nesting the CCur() function inside the Nz() function like this: Nz(PerEntryCharge, CCur(0)), but that still returned 0. I don''t know what else to try.

I believe that I have run into a similar problem before, but I can''t remember which database so I can find what I used.

推荐答案

0.00 。我尝试使用Nz（）函数（ Nz（PerEntryCharge，0），但这只是返回< b> 0 即使报告中控件的格式设置为currency。我尝试在Nz（）函数中嵌套CCur（）函数，如下所示： Nz（PerEntryCharge，CCur（0） ），但仍然返回 0 。我不知道还有什么可以尝试。


我相信我遇到过以前类似的问题，但我不记得了哪个数据库让我可以找到我用过的东西。

0.00. I tried using the Nz() function (Nz(PerEntryCharge, 0), but that just returns 0 even though the format for the control in the report is set to currency. I tried nesting the CCur() function inside the Nz() function like this: Nz(PerEntryCharge, CCur(0)), but that still returned 0. I don''t know what else to try.

I believe that I have run into a similar problem before, but I can''t remember which database so I can find what I used.

Seth，你说的听起来不太可能，但你实际上并没有说出你正在使用的东西。


我希望通过控件的format属性来格式化任何零值（显式不为零的字符串）。这似乎不会导致我相信你的解释在某个地方是错误的。由于您的解释并不准确，因此很难确切地说出可能发生的事情。


请尝试特定的方案并报告其全部细节供我们考虑。

Seth, what you say sounds unlikely, but you have not actually said what you are using precisely.

I would expect any zero value (Explicitly not a string of a zero) to be formatted by the control''s format property. The fact that it appears not to be leads me to believe your explanation is faulty somewhere. As your explanation is not at all precise, it''s hard to say exactly what may be happening.

Please try a specific scenario and report the full details of that for our consideration.

我不知道为什么我之前没有告诉你这个，我在查询中尝试这个，这是报告的记录源。 [PerEntryCharge]字段是我们服务的每单位成本。根据我们与客户达成的协议，这可能是

I''m not sure why I didn''t tell you this before, I''m trying this in the query that is the record source for the report. The [PerEntryCharge] field is the cost per unit of our service. Depending on the agreement we have with our customer this might be

这篇关于如何使Nz（）函数返回Currency值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！