访问SQL STDEV导致#error

Question

我正在尝试通过查询来计算access中字段的标准差。下面是我使用的公式：

SELECT STDev(Answers.[Answer (#)]) AS 'Standard Deviation'
FROM Answers;

当查询运行时，我得到的答案是#error。查询看起来很简单，而且我不认为我的语法是错误的。可能的问题是什么？

Answer 1

它应该是：

SELECT STDev(Answers.[Answer (#)]) AS [Standard Deviation]
FROM Answers;

要排除/忽略空值，请执行以下操作：

SELECT STDev(Nz(Answers.[Answer (#)], 0)) AS [Standard Deviation]
FROM Answers;

或者：

SELECT STDev(Answers.[Answer (#)]) AS [Standard Deviation]
FROM Answers
WHERE Answers.[Answer (#)] Is Not Null;