From the course: Access: Building a Sales Database
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
Concatenating/combining fields in a query - Microsoft Access Tutorial
From the course: Access: Building a Sales Database
Concatenating/combining fields in a query
- [Instructor] Most of the time we store people's names in two fields, first name and last name. This makes it possible to sort by last name or to search for a particular first or last name, and it makes the searching easier. You wanna find a given person's last name or put your records in order by last name, say, to do a mailing or to print labels. Remember that guy, his first name was Francis. Who did he work for? Then you'd just have to search the first name field. No wildcards needed. It's a simple search. So there's a lotta good reasons to store names in two pieces. However, there are times when that looks really clumsy, like when you're generating those labels or when you want to print out a directory and make phone calls. It can look a little odd to have the two names very far apart because they're gonna appear in two separate field boxes. So the answer to that is to, within a query, concatenate or combine the first and last name fields into a full name field. We don't do that…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.