“表单和报告”中的计算字段显示#Num [英] Calculation field in Form and Report display #Num

问题描述

您好，


我在表单和报告计算字段中遇到问题显示#Num。


ex。 fieldA / fieldB

如果fieldA或B = null，则在结果字段中获得#Num。


我怎么能搞清楚？


如果结果字段中的fieldA或B = 0（Null）=无（空白）字段


希望有人可以提供帮助。


提前致谢


问候，

Hi there,

I am having problem with form and report calculation fields showing #Num.

ex. fieldA/fieldB
if either fieldA or B=null, in the result field obtains #Num.

How can I figure out?

If either fieldA or B=0 (Null) in the result field = none (Blank) field

Hope someone there could help.

Thanks in advance

Regards,

推荐答案

null和0之间存在一个diffreence。您应该看到是否获得空值或0，如果为空，请尝试将它们更改为0，nz（值，值，如果为null）


此外，您的问题可能除以0会出错。

There is a diffreence between null and 0. You should see if you are getting nulls or 0, if nulls, try changing them to 0, nz(value, value if null)

Also, your problem may be dividing by 0 which will give an error.

你好，


我在表单和报表计算字段方面遇到问题显示#Num。


ex。 fieldA / fieldB

如果fieldA或B = null，则在结果字段中获得#Num。


我怎么能搞清楚？


如果结果字段中的fieldA或B = 0（Null）=无（空白）字段


希望有人可以提供帮助。


提前致谢


问候，

Hi there,

I am having problem with form and report calculation fields showing #Num.

ex. fieldA/fieldB
if either fieldA or B=null, in the result field obtains #Num.

How can I figure out?

If either fieldA or B=0 (Null) in the result field = none (Blank) field

Hope someone there could help.

Thanks in advance

Regards,

在null和0之间存在一个diffreence。你应该看看你是否得到空值或0，如果为空，尝试将它们更改为0，nz（值，值，如果为null）


此外，您的问题可能除以0，这将产生错误。

There is a diffreence between null and 0. You should see if you are getting nulls or 0, if nulls, try changing them to 0, nz(value, value if null)

Also, your problem may be dividing by 0 which will give an error.

感谢您的快速回复。


FieldA和B = 0

对不起，我该怎么处理您发送的代码？我怎么用呢？我真的很陌生。


提前致谢


干杯，

Thanks for quick response.

FieldA and B = 0

Sorry, What Should I do with the code you sent? How can I use it? I am really new to this.

Thanks in advance

Cheers,

感谢您的快速回复。


FieldA和B = 0


对不起，我该怎么办你发送的代码？我怎么用呢？我真的很陌生。


提前谢谢


干杯，

Thanks for quick response.

FieldA and B = 0

Sorry, What Should I do with the code you sent? How can I use it? I am really new to this.

Thanks in advance

Cheers,

如果是在VBA中，

if this is in VBA,

展开 | 选择 | Wrap | 行号

这篇关于“表单和报告”中的计算字段显示#Num的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！