IsNull and Nz

  • Thread starter Thread starter Tanuj Ralhan
  • Start date Start date
T

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access #Error & Excel Pivot 0
IsNull 2
NZ function 1
IIf(IsNull) 2
Division by Zero Error 1
Query Criteria Not Working 2
Convert nz > iif problem - stumped 1
Add function to a query 2

Back
Top