Getting External Data from Access query in Excel

[Potatohead123]

Hi,

In Excel, I'm trying to "Get External Data". The external data is a Access query. However, when I try importing it, I get this error saying "Undefined function 'NZ'in expression". How do I get around this error? I need this NZ function in my query because I do not want a NULL value.

Thanks.

Potatohead123

 

[fredericofonseca]

replace the NZ with a IIF(isnull(my_field),0,my_field)

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[Potatohead123]

thanks for your help Frederico!