Building concatenation in access

  • Thread starter Thread starter Sue at VLS
  • Start date Start date
S

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
 
Try this:

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



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

Using the plus sign to concatenate the Middle Initial will eliminate the
null values.
 
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]) )
 
Back
Top