Access数据库查询

Question

我遇到了以下字符串的挑战：

Datedeath: IIf([Members.Status]=[“DA”] Or [“DB”] Or [“DJ”] Or [“DC”], else [members.deathdate] "29/02/1844" 

有没有人可以指导我如何写这份iif声明？

Answer 1

检查条件是否满足，设置新日期或不重新设置

[members.deathdate]:IIf ((([Members.Status] = "DA"  Or [Members.Status] = "DB" Or [Members.Status] = "DJ" Or [Members.Status] = "DC") And ([members.deathdate] = "" Or IsNull([members.deathdate]))), "29/02/1844", [members.deathdate])