AnsweredAssumed Answered

Client calculation?

Question asked by AndrewJudd on Jan 18, 2015
Latest reply on Jan 18, 2015 by AndrewJudd


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!