You can simplify it a little to help avoiding errors, since it is always first and last. [FirstName] & " " & [lastName] & IIf(IsNull([BillingLastname]),"(Student)","(Billing)") Thanks, that is easier to read as well.