Combine Two or More Fields Together Using Concatenation in Microsoft Access

In this video, I will show you how to put two or more values together in your Microsoft Access database using concatenation. You can join text strings, numbers, currency values, and all kinds of things. I'll show you how to concatenate using a query, and then directly inside a form or report.

Bridget from El Paso, Texas (a Platinum Member) asks: I'm creating a combo box on my order form to pick a customer. It seems you can only see first name OR last name in the combo box while it's closed, but they both are in there when it's open. How can I see them both?

Silver Members and up get access to an Extended Cut of this video. Members will learn how to use Null Propagation to get rid of the comma if there is no first name in a Last, First scenario. We'll also see how to concatenate currency values (and make them look like currency values) as well as numbers with a specific format, such as phone number or SSNs.

MEMBERS VIDEO:

BECOME A MEMBER:

LEARN MORE:

LINKS:

COURSES:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, concatenate, concatenation, concatenating, combine text values, combine strings, get rid of comma, null propagation, concatenate related rows, concatenate multiple records, concatenate fields in report, concatenate fields in form, join fields, format function, trim function

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[rannysay]

Thank you. You're super super brilliant. All your videos are amazing and very helpful. God bless you.

[jerryb]

Can you use concatenation formulas for the unique ID field

[kevinsuszek]

I'm able to do this just like instructed. I built a for to add new records to my table via a query, but it won't add to concatenation. How can I get this to do that?

[ziadbakdounes]

Hi,
I created a form in Access with the contents of a store using the form wizard
There are three fields in the form that I want to link together (price, number, total).
What is the appropriate formula for this?
with many thanks.

[dimbal_]

Good start for my query, thanks for explanation!

What about if both fields ([FirstName] and [LastName]) are multiple values? Is that possible to combine at all?

[HamedAllawi]

Hello, what if we had three field First_Name, Middle_Name, Last_Name and we need to concatenate them but some times middle name is null then the method you provide will add an extra space of letter if we used this for example:
First_Name = “Mike”
Middle_Name = Null
Last_Name = “Anderson”
Using this:
=[First_Name] & ", " & [Middle_Name] & ", " & [Last_Name]
If Middle name is null as we said before the result will be //Mike, , Anderson// wilth double (, ) instead of Mike, Anderson
Does it have a solution ?

[amgrechlarosa]

Would be great if you could do a video showing records of the same field being concatenated. Im trying to put names after each other with with a ', ' in between each name and an 'and' before the last one in a report (eg: James, John and Michael did not attend today's meeting). I'm using a predefined function in VBA to do this but it doesn't seem to want to work on a query of a query but it does work on a table or query. Happy new year and thanks for your content

[akokohjoel]

Pls rost, can you show us how to make ms access work online with Microsoft SQL server? Thanks

[martinx]

it doesn't work for me. In my case I have [COUNTRY].[name] & "..."