[AccessD] IIf with three fields

[Kostas Konstantinidis]

Hi all,
I am a little confused about how to make IIf to work in query with three
different phones fields while all or any of them may be null

I use 

IIf([mobile] Is Null; [phone_home]; IIf([phone_home] Is Null; [phone_job];
IIf([phone_job] Is Null; 
[phone_home] & ", " & [mobile]; [phone_job] & ", " & [phone_home] & ", " &
", " & [mobile])))

But it doesn't work in all cases

Any help please?
Thank's
/kostas