本文介绍了解决Microsoft ODBC MS Access Driver中遇到的'NZ'函数未定义的问题。由于ODBC不支持所有函数，建议使用IIf(IsNull([MyField],0,[MyField]))替代NZ([MyField],0)。
Microsoft ODBC MS Access Driver - Undefined function 'NZ' in expression.
thank you, it worked!
Quote:
> ODBC doesn't allow all functions, and I believe NZ is one of the ones it
> doesn't allow.
> doesn't allow.
> Try IIf(IsNull([MyField], 0, [MyField]) instead of Nz([MyField], 0)
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
