Recent content by broberts

Thanks, that is easier to read as well.

I got it.... I was putting the expression in the criteria box instead of the field box. Silly mistake. Thank you all for the input!

Query is not included because I am not able to save the object with the error. The query includes the calculated field as well as InstanceID, TotalCost, BalanceDue, Phone, and Email.

Here is a copy. It is a textbook assignment so none of the info is real/sensitive.

Payer: IIf(IsNull(BillingLastName), FirstName & " " & LastName & " (student)", BillingFirstName & " " & BillingLastName & " (billing)") This is my final version of the expression I've tried... I see no syntactical errors but I still have one apparently.

Thanks, will try this!

This returns the same error. I do not believe that the database has any other problems with relationships between these tables, so the issue is isolated to just this expression.

I made sure to type this exactly as you have sent it. The query still returns an error.

Yes, (Student) and (Billing) are meant to be concatenated depending on the value of the expression as text at the end of the field. Code still gets the same error referencing . (dot) or ! operators or invalid parentheses.

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...