Microsoft Content Management Server

Author

Access 97 question

2007-02-21, 1:16 pm

I am trying to join fields in a Trim function using the "&" symbol eg
[MotherTitle],[MotherFirstName], [MotherSurname], [FatherTitle],
[FatherFirstName] and [FatherSurname]) to give a result of (for example): Mr
John Smith & Mrs Betty Smith.
I can do this as long as there are both people in that client's record, but
if one is missing, it will show up as "Mr John Smith &" or "& Mrs Betty Smith"
Any suggestions on how to join these in a TRIM function and have the "&"
symbol not appear??