AnsweredAssumed Answered

adding a variable

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


adding a variable


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:


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.