Can someone please tell me what I have done wrong to not be able to get this to work. I'm used to doing nested iff staements in Excel, but not access.
IIf(([DateUpdated])IsNull,iif([GoogleSearchVerifiedDate] isNull OR [DirectorInsolvencyInfoReceivedDate] IsNull, "Incomplete",iif([GoogleSearchVerifiedDate] IsNull OR [DirectorInsolvencyInfoReceivedDate] IsNull, "Incomplete","Complete"),"Complete")
Regards