Help with sql statement PLEASE

Hi, I am building an intranet soft in asp language, but the problem is in the sql I need to build
So i didn't see an asp board, tought in putting it here..
please help:
I need to use a function that returns a number if null
I know there is NZ for access and ifnull for MySql
But, When i try to use NZ or ifNull within my sql statement, it gives me this error:
Microsoft JET Database Engine (0x80040E14)
Function 'NZ' undefined in the expression.
and when I try to use isnull with two parameters, it says to me that I can't use two parameters for isNull
Any ideas please??

Thanks

Comments

  • Did you try ISNULL() or IFNULL() ? The latter should work with two parameters.


    : Hi, I am building an intranet soft in asp language, but the problem is in the sql I need to build
    : So i didn't see an asp board, tought in putting it here..
    : please help:
    : I need to use a function that returns a number if null
    : I know there is NZ for access and ifnull for MySql
    : But, When i try to use NZ or ifNull within my sql statement, it gives me this error:
    : Microsoft JET Database Engine (0x80040E14)
    : Function 'NZ' undefined in the expression.
    : and when I try to use isnull with two parameters, it says to me that I can't use two parameters for isNull
    : Any ideas please??
    :
    : Thanks
    :

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion