From the course: Access 2007: Shortcuts

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Using concatenated fields

Using concatenated fields - Microsoft Access Tutorial

From the course: Access 2007: Shortcuts

Start my 1-month free trial

Using concatenated fields

You will sometimes find it useful to take the data in two different fields and merge it into one field. For example, a well-designed database has separate fields for last name and for first name. But there are times when you'll want to have that person's full name in one field. Here is how to do that using an expression technique called Concatenation. Concatenation is done in a query, and then you base your forms and reports on that query instead of on the original table. Another possibility is to use a Make- Table query to convert your current table to a new table that includes the new concatenated field. The latter technique is fine for a one-time conversion, but it's not practical for ongoing use. I'll show you how to do both. The most common technique is to make a query containing the concatenation expression and to use that new query as the basis for your formal report. We already have a report based on a query. My Sales Reps Phone List Query pulls specific fields out of my Sales…

Contents