asp and access

[sweetleaf]

Hi,

I have an asp page that retrieves records from an access system and displays results in an html table.
One of the columns which i am querying is an expression which adds the values of other columns in the query grid like this:

a: nz([field1]) + nz([field2])

However, asp gives me the following error:

Microsoft JET Database Engine error '80040e14'
Undefined function 'nz' in expression.

Does anyone know a way around this?

Any and all help is greatly appreciated!

 

[Ladyhawk]

What's nz? Is that the recordset object? Ladyhawk.
** ASP/VB/Java Programmer **

 

[JDavey]

In Access, "nz" is a built-in function that replaces a "NULL" value with another specified value. However, I think it should have two arguments, the first being the expression to test, and the second being the string to return if the result of the expression is null. To use this function from asp, you probably need to set a reference in the asp page to the Access dll. It may be easier to handle the test for null through code.