AnsweredAssumed Answered

adding a variable

Question asked by brucewashington on Jun 24, 2010
Latest reply on Jun 24, 2010 by brucewashington

Title

adding a variable

Post

MP 11 Advanced  and Windows Vista Business

I want a field that will take one field (the full name) and add it to a phone number choicing Phone 1 (home phone) first and if empty choosing Phone 2 and if that one is empty choosing Phone 3.

 

I had it work for two phones only but adding the third, two come in blank.

 

My two phone variable is:

 

Case(
Phone = "" ; Name_Full &" " & Phone3 &" "& Phone3_Ext ;
Name_Full &" " & Phone &" "& Phone_Ext )

 

No problem.

 

How to add the new variable into the equation is what has got me.

 

Any ideas appreciated.

 

Outcomes