Joining Multiple IIf Statemetns (Access 2003 SP1)

Topic

New Reply

I’m trying to create a column to populate with 3 conditions. See below. Can someone help??

Method: IIf([Call Start] Is Not Null,”IVR”) Or ([MinOfDate] Is Not Null & [Call Start] Is Null,”LMS”) Or ([Call Start] Is Null & [MinOfDate] Is Null,”N/A”)

Reply | Quote

Replies

Method: IIf([Call Start] Is Not Null,”IVR,iif([MinOfDate] Is Not Null & [Call Start] Is Null,”LMS”, iif([Call Start] Is Null & [MinOfDate] Is Null,”N/A”)))

Reply | Quote

To combine conditions, use AND instead of the concatenation operator &. And use the IsNull(…) function to test if a value is null:

Method: IIf(Not IsNull([Call Start]),”IVR”,IIf(Not IsNull([MinOfDate]),”LMS”,”N/A”))

Reply | Quote