Hello, I have been having an issue with a query that returns an error:
The expression you entered has an invalid . (dot) or ! operator or invalid parentheses.
You may have entered an invalid identifier or typed parentheses following the Null constant.
The query is meant to create a calculated field named Payer that concatenates FirstName, a space, LastName, and (student) if the BillingLastName field is null. Otherwise, the calculated field should concatenate BillingFirstName, a space, BillingLastName, and (billing).
Here is my code:
Payer: IIF(IsNull(BillingLastname), Firstname & " " & Lastname & ", " & (Student), BillingFirstname & " " & BillingLastname & ", " & (Billing))
The expression you entered has an invalid . (dot) or ! operator or invalid parentheses.
You may have entered an invalid identifier or typed parentheses following the Null constant.
The query is meant to create a calculated field named Payer that concatenates FirstName, a space, LastName, and (student) if the BillingLastName field is null. Otherwise, the calculated field should concatenate BillingFirstName, a space, BillingLastName, and (billing).
Here is my code:
Payer: IIF(IsNull(BillingLastname), Firstname & " " & Lastname & ", " & (Student), BillingFirstname & " " & BillingLastname & ", " & (Billing))