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;