Hey.

I have been trying to get this IIF function to work correctly for what i want it to do. But i keep on getting this error message when doing it "The expressions syntax is unvalid" (dont know if my transslation was 100% correct there about the error message).

The thing i want to do is this:
I have a feild called phone and one for cellphone and i want the IIF function to show the cellphone nr first. If it doesnt have a cellphone nr in it I want it to show the phone nr instead. And if i doesnt have a cellphone or a ordinary phone to give me a message "Missing number".

I have tried to use this:

Contakt: IIF(IsNull([Cellphone]),[Phone],"Missing Number")

But that doesnt work. So i tried this:

Contakt: IFF(IsNull([Cellphone]),[Phone],[Cellphone])

But that doesnt work either. Have tried Moore things but nothing can make the IIF function to get anything other than the syntax error message. What am  doing wrong and how should i do this IIF function to make it work?

---

Reply from Alex Hedley:

IIF Function (Glossary)
=IIF(Condition, Value If True, Value If False)

What is your outcome for 'Contakt', does it show any value?

Checks:
Len(Nz(Me.controlname, "")) = 0
len(string) < 1
string = ""