Access 2016 IIF（超过 2 个条件）

Question

我需要帮助，我需要更正下面的代码。我有 3 个条件需要满足。如果所有 3 个条件都满足，则给我单词，"Active"如果不满足，则给我单词"Inactive"。

Expr1: IIf([Master COA STATUS]="Active" AND [Active / Inactive]="Active" AND [Paylocity and GL DEPT]="Active","Active","Inactive")

Answer 1

以下是查询的示例 SQL 语句：

SELECT Tabelle1.ID, Tabelle1.[Master COA Status], Tabelle1.[Active / Inactive], Tabelle1.[Paylocity and GLDept],
IIf([Master COA Status]="Active",IIf([Active / Inactive]="Active",IIf([Paylocity and GLDept]="Active","Active","Not Active"),"Not Active"),"Not Active")
AS Ausdr1 FROM Tabelle1;