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)