Access instructions are unable to run queries with NZ( )

Step configured to run a query on a Microsoft Access database that contain the NZ() function fail.

Why does this happen?

This function is not supported in the underlying drivers that run queries against Access data sources.

How to fix this

There is an alternative to the NZ( ) function, IsNull(). Use the IsNull() function instead.

Recommended Posts

Leave a Comment

Contact Us

To learn more about SolveXia, please use the form below to send us an email. One of our team members will contact you.

Not readable? Change text. captcha txt

Start typing and press Enter to search