text string

[cbrsix]

I have the following in a text box on a report and need help finishing it up.

="Dear" & " " & Trim([Account List.First Name]) & IIf([Account List.Account Type]="JTIC" Or [Account List.Account Type]="JTWROS" Or [Account List.Account Type]="JTENT",Trim([Account List.Joint Owner/Child First Name]),"") & ","

I want it to look like this:
Dear Joe,
or
Dear Joe & Jen

I can't figure out how to add in the " & " infront of the second persons name.

[pbaldy]

Does this work?

="Dear " & Trim([Account List.First Name]) & IIf([Account List.Account Type]="JTIC" Or [Account List.Account Type]="JTWROS" Or [Account List.Account Type]="JTENT", " & " & Trim([Account List.Joint Owner/Child First Name]),"") & ","

[boblarson]

First off, you don't need to include

& " " &

after the ="Dear" part. Just put a space after Dear:

="Dear " & Trim([Account...

Second, you can just use

"JTENT"," & " & Trim([Account...

or use

Chr(38) for an ampersand if you wish.

[boblarson]

oops, I typed too slow this time

[cbrsix]

Thanks it works now.