**** OK !!!! I figured it out thanks to your help!! ****
Your link to the on line version of help did the trick....
This is what it looks like now....
trim(coalesce([Company] ,[Last Name] || ', ' || [First Name],[Company],[Email (Work)],[Email (Home)],'(New Contact)'))
Thanks, Anne
:-)
|