Microsoft Access String Concatenation
Putting together two or more text fields, such as FirstName and LastName
Q: I have my customers' first and last names in separate
fields like you've shown me. Now, how can I put them back together into
one field so I can make letters and other reports?
A: All you have to do is use a
little string concatenation to put them back together again. For
example, in your case, just make a new
calculated field in
your query called FullName and set it equal to:
FullName: FirstName & " " & LastName
Here is a FREE VIDEO TUTORIAL
that will walk you through an example of string concatenation. It's
much easier to show you how it's done than to explain it here.
I teach the concepts in this free mini tutorial in my
Access 104 course. These are
full courses - over 60 minutes in length each. I spend a lot more time going
over how to do this, in addition to lots more tips and tricks.
| 
