Hello
How do I remove spaces between text that is concatenated. I tried using LTrim and RTrim but that did not work. Here is the expression I am currently using: Trim([Buildings_Crosstab]![1] & " " & [Buildings_Crosstab]![2] & " " & [Buildings_Crosstab]![3] & " " & [Buildings_Crosstab]![4] & " " & [Buildings_Crosstab]![5] & " " & [Buildings_Crosstab]![6] & " " & [Buildings_Crosstab]![7] & " " & [Buildings_Crosstab]![8] & " " & [Buildings_Crosstab]![9] & " " & [Buildings_Crosstab]![10] & " " & [Buildings_Crosstab]![11] & " " & [Buildings_Crosstab]![12] & " " & [Buildings_Crosstab]![14] & " " & [Buildings_Crosstab]![16] & " " & [Buildings_Crosstab]![17])
How do I remove spaces between text that is concatenated. I tried using LTrim and RTrim but that did not work. Here is the expression I am currently using: Trim([Buildings_Crosstab]![1] & " " & [Buildings_Crosstab]![2] & " " & [Buildings_Crosstab]![3] & " " & [Buildings_Crosstab]![4] & " " & [Buildings_Crosstab]![5] & " " & [Buildings_Crosstab]![6] & " " & [Buildings_Crosstab]![7] & " " & [Buildings_Crosstab]![8] & " " & [Buildings_Crosstab]![9] & " " & [Buildings_Crosstab]![10] & " " & [Buildings_Crosstab]![11] & " " & [Buildings_Crosstab]![12] & " " & [Buildings_Crosstab]![14] & " " & [Buildings_Crosstab]![16] & " " & [Buildings_Crosstab]![17])