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..
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??