Add multiple spaces between fields in a concatenationg calculation
I thought this should be easy but ...
I have a calculation that concats multiple fields
orders::OrderKey &" " & orders::cOrderDate & " " & subjectdetails::Name
You can see I have added a space between the fields - enclosed by quotes.
But how do I add multiple spaces? I want more than one space between the fields in my result. I I simply add more into the calculation they are stripped back to a single space in the result.
Can I add multiple spaces or a tab ?