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!