如何使Nz（）函数返回Currency值？

本文介绍了如何使Nz（）函数返回Currency值？的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 我有一份报告，我用它作为发票向我们的客户收费。有些指控是空白的。我希望能够拥有它，如果值为空，则将 $ 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.推荐答案 这篇关于如何使Nz（）函数返回Currency值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！