An example is trying to combine first name and last name into fullname from a table thats called employee. What expression do I type in the Control Source? I've typed FullName: [First] & " " & [Last] but it kept saying error.
Asked
Active
Viewed 2,739 times
-1
DanielBarbarian
- 5,093
- 12
- 35
- 44
Macy
- 3
- 1
- 2
-
"kept saying error" - Yeah but *which*? – CherryDT May 22 '16 at 08:46
1 Answers
0
=[First] & " " & [Last]
Should do it.
To avoid complications with nulls use:
=Nz([First], "") & " " & Nz([Last], "")
JJ32
- 1,034
- 1
- 7
- 24
-
Their is a list of names and I'm using the same expression you've mentioned but the first list of name keeps appearing. How do I change it to the next name? – Macy May 20 '16 at 06:24