FYI: MSAccess connector cannot use queries that have the NZ() function

[Drew-3030]

Hi All,

Found this out the hard way, as the query and all child queries do not appear in the list of objects when connected to the Access Database as a source.

solution is to replace the convenient NZ() function with an IIF() statement
original

Nz(MAP.chkCOE,"n")

Replacement

IIf(Trim(MAP.chkCOE) = "" or IsNull(MAP.chkCOE), "n", MAP.chkCOE)

Cheers

Andrew