IsNull and Nz

[Tanuj Ralhan]

Hi Everybody

What is the difference in IsNull and Nz functions in
access2000. when make queries using IsNull functions and
use it thru my VB6 program, it works fine whereas queries
using Nz function works fine in access2000 but using these
queries in VB6 proram I get:

Run-time error '-2147217900 (80040e14)':
Undefined function 'Nz'in expression.

Why is it so. Is it that Jet driver in VB6 doesnot know Nz
function and IsNull function is defined in jet.

 

[Lynn Trapp]

NZ is an Access specific function and is short for Null To Zero. It's
purpose is to replace a Null value with some other value when a Null is
detected. IsNull merely returns a boolean value for when a Null value is
found and you must then decide what action to take.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Security FAQ: http://support.microsoft.com/support/access/content/secfaq.asp