Carriage Return Please

[Mickdn]

How can I get the following calculation to place a Carriage Return at the end of LastName so it will display as

Fred Arthur Smith

666 Green Street

Have read lot's of post's but can't seem to get it working.

Substitute (List(FirstName;MiddleName;LastName;Address);"¶";" ")

Thanks

[doughemi]

Substitute (List(FirstName;MiddleName;LastName);"¶";" ") & "¶" & Address

[Lee Smith]

Are you saying that your data is all in one field?

i.e. Fred Arthur Smith 666 Green Street, or are you wanting to combine two or more fields?

If your data is all in a single field like you describe, or two fields (one for full name and one for street), then you need look at changing your data structure and have separate fields for First Middle and Last.

Lee

[Mickdn]

Thanks doughemi, must have tried every combination except that one.

Thanks also to Lee but my data structure is just fine and I do have separate fields for all my data.

The example I used was just that, an example.

Enjoy your holidays!