Building concatenation in access

[Sue at VLS]

Hello, I want to prepare an update query which will
concatenate other fields (first name, middle name, last
name) into a "name" field. I can do this but my problem
is that sometimes a middle name is blank and I can't seem
to trim the spaces out of it. I've tried RTrim but
doesn't seem to work.

Any thoughts?

Thank you in advance.

Sue

 

[Cheryl Fischer]

Try this:

([First name] + " ") & ([Middle Initial]+ " ") & ([Last name])



hth,

 

[Lynn Trapp]

[FirstName] & " " + [MI] & " " & [LastName]

Using the plus sign to concatenate the Middle Initial will eliminate the
null values.

 

[GaryS]

Here's how I use Trim in a similar circumstance (to form a
botanical name out of genus, species, and variety):

Trim([First name] & " " & Trim([Middle Initial]& " " &
[Last name]) )