Hi...I have a business card in PSM and on one line will be displayed the Telephone and fax numbers if they exist. I have a database field for the phone and one for the fax. The expressions I have created so far works well, but when the PHONE number does exist and the fax number does not is there an expression that I can add to the below PHONE field expression?
I would like to add like an OR expression to say state If the tel & Fax exist, display Tel: 00000, Fax: 00000 OR IF PHONE exists and Fax does not, display Tel: 000000. can I do that in one expression or am I approaching this in the wrong way. I've tried OR, but can't get it to work.
For PHONE field
IF([PHONE] > "" AND [FAX] > "",("Tel:"&" "& [PHONE]&", Fax:"&" "& [FAX]),"")
Displays Tel: 0207 88 77 88, Fax: 0207 88 88 11 or nothng
and for FAX field
IF([PHONE]="" AND [FAX]>"","Fax:"&" "& [FAX],"")
Displays Fax: 0207 88 88 11 or nothing