=iif
(
[countryRegion] = "US",
"United States",
iif
(
[countryRegion] = "Canada",
"Not United States",
"somethign else"
)
)
=IIf([CountryRegion]="US", "No", [CountryRegion]="Canada","No")Could someone show me a example of a nested IIF statement
=IIf([CountryRegion]="US", "No", "Yes")
I wanted to also list Canada as No would I use a nested statement ? Here if so could someone give me an example ?
Sorry for post #3 its wrong. The easiest nested If in access is the use of SWITCH function. That's what I wanted to use. So it should beCould someone show me a example of a nested IIF statement
=IIf([CountryRegion]="US", "No", "Yes")
I wanted to also list Canada as No would I use a nested statement ? Here if so could someone give me an example ?