access遇有空值，不能自动求和怎么办？

girder

我也要学习一下，我也遇到这个问题了

abc123qqq

学习，我是启蒙班的

yinglai

感谢分享。

girder

nz非常好的函数

liujchen

nz 不加任何参数，应该是zeroifnull() 对于数字类型
或者应该说coalesce()

In Access, the Nz function lets you return a value when a variant is null.

The syntax for the Nz function is:

Nz ( variant, [ value_if_null ] )

variant is a variable that is a variant datatype.

value_if_null is optional. It is the value to use when the variant is a null value. If this parameter is omitted and the variant is a null value, the Nz function will return a zero or a zero-length string.