Using concatenated fields


show more Using concatenated fields provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts show less
please wait ...

Using concatenated fields

You will sometimes find it useful to take the data from two separate 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 want to have that person's full name in one field. Here is how to do that. I am going to open up my SalesReps table and move it into Design View. First I need to add the new field. I will right-click on the gray box to the left of Address and choose Insert Rows. I will type in capital F, Full, capital N, Name (FullName) with no space.

For my Data Type, I will drop it down and I will choose Calculated. Immediately, the expression builder appears. Double-click on the First Name in the Expression categories column and it will appear at the top. To add more text to the string, we need an ampersand or an and sign, go ahead and type it to put it in a space, type a quotation mark, and a space and then a quotation mark again. The quotation mark tells Access to add on whate...

Using concatenated fields
Video duration: 2m 16s 3h 43m Intermediate

Viewers:

Using concatenated fields provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts

Subject:
Business
Software:
Access
Author:
please wait ...