Access db query

Question

I'm having a challenge with the following string:

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

Might someone be able to guide me as to how to write this iif statement please?

Answer 1

Check if the condition fulfilled, set new date or leave it

[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])