I have run the StDev function in both MS Access and SQL Server with the same exact data. The two pieces of data 2.32 and 2.32 should result in a StDev of 0, the result which SQL Server generates. MS Acccess generates the following result however... 4.2146848510894E-08. This poses serious issues for my database logic, but I'm not interested on how to fix it but rather if anyone else has run into similar issues and if anyone knows why these calculate different results?