cliffs
Discoverer
Member since ‎2023 Oct 11

User Statistics

  • 3 Posts
  • 0 Solutions
  • 1 Kudos given
  • 0 Kudos received

User Activity

Hi, I have 5 fields, Company; Title; Forename; Othername and Surname, and I want to join them together. I've created a formula field, companypersonname, and used the following formula: TRIM({Company}&" "&{Title}&" "&{Forename}&" "&{Othername}&" "&...
test-data-2023-10-11.pngI’m having a terrible time with some of Crystal's functions. I’ve enclosed some sample data for you. In table 1, there is the result of a query with some tables joined together and the fields I want in the order I require....
Kudos given to