In my database I have input customers names in three columns Last, First and MI. I used the phrase below.....
IIf(IsNull([Last]),IIf(IsNull([First]),[First]),IIf(IsNull([First]),[Last],[Last] & ", " & [First]))
to get the whole name to appear in one column...example Smith, John T.
Heres where I...