Concatenate Strings of Data Together in Microsoft Access
http://www.trainsignal.com/Microsoft-...
Oftentimes you may find certain data separated across multiple fields in your Access database, such as a First Name field and a Last Name field, when in the end you'd like this data to be displayed in one single field inside a query, form, or report. In this clip, Train Signal's Heather Ackmann shows you how to join strings of data together through concatenation and what to do when some of those joined fields contain null values.