I have created a new variable by adding together to objects, first name, and last name. =[BRC First Name]+""+[BRC Last Name]. However, when it shows up on my report there is a large gap of space between the first and last name. Not sure what I’m doing wrong I have the “” between the two for no spacing.
There are probably spaces within the first or last name fields themselves. Most databases have a trim() function that you can use to remove these. Something like:
=trim([BRC First Name])+""+trim([BRC Last Name])
However, if you do that, you will see the first name and last name smacked together without any spaces at all, like this: