Hi Guys 
 
 I am facing a strange problem i have an  asp page using Nz function and 
my database is Access 2000. i want to display the best matches when some 
user is searching the site but i am getting the following error,

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Undefined function 'Nz' in 
expression.
/sm/advance-search-result.asp, line 358

anyone can help me ?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <bimal@o...>
Subject: [asp_databases] Re: Access nz fuction doesn't work in Asp---Can u
Help


:  I am facing a strange problem i have an  asp page using Nz function and
: my database is Access 2000. i want to display the best matches when some
: user is searching the site but i am getting the following error,
:
: Error Type:
: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
: [Microsoft][ODBC Microsoft Access Driver] Undefined function 'Nz' in
: expression.
: /sm/advance-search-result.asp, line 358

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Checking archives leads to:
http://p2p.wrox.com/archive/asp_web_howto/2002-11/4.asp

which leads to:
http://support.microsoft.com/default.aspx?scid=KB;en-us;q189448

You could use IIF() instead.

Cheers
Ken