1. What is the limit to the number of nested IIf statements in a calculated query? Is there a limit to the number of conditions within an IIf statement?
2. I am getting the following error message when running a select query with a calculated field:
The expression you entered contains invalid syntax
You may have entered an operand without an operator
I have edited this calculated field trying to identify the problem, but I continue to get this error message with the field being as simple as:
When I save this language it changes the syntax to: test: IIf([lname]="smith",["A"],["B"])
When I run the query with this field I am asked for parameters for A and B (of course)