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:
• Microsoft Access Concatenation MEMBER...
BECOME A MEMBER:
YouTube: / @599cd
or My Site: https://599cd.com/THMember
LEARN MORE:
https://599cd.com/Concatenation
LINKS:
Calculated Query Fields: https://599cd.com/Calculated
Invoicing: https://599cd.com/Invoicing
Double Double Quotes: https://599cd.com/DoubleDouble
Combining Names: https://599cd.com/CombiningNames
Access Beginner Level 9: https://599cd.com/ACB9
Concatenate Records: https://599cd.com/DLookupPlus
COURSES:
FREE Access Beginner Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter: / learningaccess
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...
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.
Watch video Combine Two or More Fields Together Using Concatenation in Microsoft Access online without registration, duration hours minute second in high quality. This video was added by user Computer Learning Zone 23 August 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 40,07 once and liked it 21 people.