IsNull

[afortney]

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]

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