MS query, Excel 97 and Access 97

[chifu]

In Excel, I want to pick the results of a query from Access by using MS Query.

I can link to Access using MS Query and have obtained simple query results, but whenever the Access query uses the Access function NZ(), MS Query fails with the error "undefined function nz in expression".

Anyone know how to get around this?

Many Thanks.

 

[xlhelp]

ODBC does not support Nz(), EuroConvert(), or Eval().

Instead of Nz([MyField], 0)
try
If(IsNull([MyField], 0, [MyField]) instead of Nz([MyField], 0)
"A married man should forget all his mistakes. There is no point in two people remembering the same thing."