Multiple IIFs

[Rich]

americans wouldn't understand European Geography

 

[aftabn10]

thanks guys for all your help.

gemma-the-husky managed to give me the correct answer . Really appreciate it.

the following is the formula that i used in my query:

Query: IIf(nz([Europe],0)>0 And nz([UK],0)>0,"Neither",IIf(nz([Europe],0)>0,"Europe","UK"))

 

[vbaInet]

gemma-the-husky managed to give me the correct answer .

I'm confident he surpassed the word "manage" lol