IsNull (1 Viewer)

afortney

Registered User.
Local time
Today, 16:30
Joined
Aug 2, 2001
Messages
12
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

Registered User.
Local time
Today, 09:30
Joined
Dec 17, 1999
Messages
1,332
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
 

Users who are viewing this thread

Top Bottom