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'
Printable View
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'
Is STDev a recognized function in Access?
------------
Adam Fortney at 8/2/01 3:00:48 PM
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'