<div>
<br />
No comment has been added lately, so it's time to clean up this TA.<br />
I will leave a recommendation in the Cleanup topic area that this question is:<br />
&nbsp;- Answered by: TextReport &nbsp;<br />
Please leave any comments here within the <br />
next seven days.<br />
<br />
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !<br />
<br />
Nic;o)
</div>



No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
 - Answered by: TextReport  
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)

<div>
per recommendation<br />
<br />
SpideyMod<br />
Community Support Moderator @Experts Exchange
</div>


per recommendation

SpideyMod
Community Support Moderator @Experts Exchange

<div>
<div class="content wysiwyg-content">
I connect to an Acces DB via an ODBC connection. When I try to send a sql-statement like<br />
<br />
SELECT nz(Max(TNR),0)+1 FROM tau_Taucher;<br />
<br />
to the DB i receive this<br />
<br />
Undefinierte Funktion 'nz' in Ausdruck<br />
<br />
engl.: undifened function 'nz' in expression<br />
<br />
My software ist written in JAVA. I use WIndows 2000 and the Access ODBC Driver 4.00.6200.00.<br />
<br />
Did someone know what went wrong?<br />
<br />
Bye<br />
<br />
Arndt
</div>
</div>


I connect to an Acces DB via an ODBC connection. When I try to send a sql-statement like

SELECT nz(Max(TNR),0)+1 FROM tau_Taucher;

to the DB i receive this

Undefinierte Funktion 'nz' in Ausdruck

engl.: undifened function 'nz' in expression

My software ist written in JAVA. I use WIndows 2000 and the Access ODBC Driver 4.00.6200.00.

Did someone know what went wrong?

Bye

Arndt

ODBC and NZ

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.