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 )
How to add the new variable into the equation is what has got me.
Any ideas appreciated.