sql - DateAdd SQL代码语法错误

Question

在访问查询中运行此SQL代码时，我一直收到以下错误。知道为什么吗？

错误:
查询表达式“状态日期”中的语法错误(缺少运算符)

码:

FROM [Owner Training Report]
WHERE ((([Owner Training Report].[Status Date])>DateAdd("m",12,Date())) AND (([Owner Training Report].[Reporting Basic Status])="Completed"));

Answer 1

您可能具有Null值，所以请尝试:

WHERE (Nz([Status Date],Date()) > DateAdd("m",12,Date())) AND ([Reporting Basic Status] = "Completed");