View Full Version : IsNull


afortney
08-02-2001, 11:33 AM
I can get the following statement to work in SQL Server, but cannot get it to work on Access, please help

select isnull(stdev(myvalue2),0) as mystdev from tempstdev where myvalue2>0 and sessionvalue = '25768'

Travis
08-02-2001, 11:53 AM
In Access IsNull does not have two variables.

Access:
IsNull(Expresion) = True/False

SQL Server:
IsNull(Expression,[Value to Return if Null])


Access has a function Nz (Null to Zero) that works like the SQL Server IsNull.

HTH