2 Replies Latest reply on Jan 18, 2015 4:28 PM by AndrewJudd

    Client calculation?



      Client calculation?


      Hi there, I have a field in my client table which generates a preview of the client information. So it can be easily read and used throughout the database, address labels etc. This calculation is as follows:

      First Name & " " & Last Name & If(not IsEmpty (Company) ; ¶ & Company) & ¶ & If(IsEmpty (Title) ; Address) & If(not IsEmpty (Title) ; Title & ¶ & Address)

      The issue I have is a person's title appears after their company name. It should really be above. Can anyone help re-order this for me? thanks!