elseif type function in query

[moorsey]

i have the following query statement:

intext: IIf([calllogs]![InternalCall],"0","External")

in "InternalCall" there is either a "0" or a "1", these represent external and internal calls

So I want to turn the "1" and "0" into "internal" and "external"

I've done half of it, but I can't use an "else if" statement in the query, the only other option is to have one field for internal and one box for external with seperate iif statements which I want to stay away from...

 

[KenHigg]

intext: IIf([calllogs]![InternalCall]=0,"External","Internal")

???

 

[moorsey]

unbelivable, I completely didn't look at the iif format properly, thanks for pointing out my mistake!!!

 

[KenHigg]

unbelivable, I completely didn't look at the iif format properly, thanks for pointing out my mistake!!!

Been there