I use Excel Macro to run some Access query. NZ function works fine in Access.
But it doesn't work when I was connecting to Access through Excel macro. The
error message says it doesn't recognize the "NZ" function.

Could anybody help me to find a way around?
MY ADO library version is 2.7, I don't know if that is the problem.

Thanks!