Concatenation

  • Hello, any advice appreciated please.

    I have an expression to put an address in a report:

    =fields!address1.value & ", " & fields!address2.value &", " & fields!address3

    However this returns:

    1, Smith Street , Anytown

    I would like it to read:

    1, Smith Street, Anytown

    I would be be very grateful if you're able to suggest the right expression to achieve this - thanks.

  • Solved by:

    =Ltrim(Rtrim(fields!address1.value)) & ", " & Ltrim(Rtrim(fields!address2.value)) &", " & Ltrim(Rtrim(fields!address3))

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply