Solved Query Error (1 Viewer)

broberts

New member
Local time
Today, 08:18
Joined
Sep 5, 2023
Messages
10
You can simplify it a little to help avoiding errors, since it is always first and last.
Code:
 [FirstName] & " " & [lastName] & IIf(IsNull([BillingLastname]),"(Student)","(Billing)")
Thanks, that is easier to read as well.
 

Users who are viewing this thread

Top Bottom