carriage return in a calculation

[z178]

I have a database that has a field for adding notes.I was using this calculation to add new notes so that each entry is on a new line.

Here is the calculation I used

[color:blue]MyDatabase::Notes & [color:green]"Email sent

[color:green]"

&[color:green]"Pending Approval[color:green]"

I expected a result like this-

[color:orange]Email sent

Pending approval

However I got a result like this-

[color:orange]Email sent Pending approval

In other words can I add escaped characters like r in a calculation. How else can I achieve the same result?

[Vaughan]

Use the pilcrow "¶" character: on a Mac it's Option-7.

MyDatabase::Notes & "Email sent¶Pending Approval"

[z178]

Thanks