I need help with the syntax in a calculated field. I will give you an example of what I am trying to accomplish.
Yes and Out of State $9,000 result in field $9,000
No and Out of State $6,500 result in field $6,500
No and In State $5000 result in field $5,000
Yes and In State $7,500 result in field $7,500
Result: IIf([y/nField]=-1,[InStateAndYes],[InStateAndNo]) And (IIf([y/nField]=0,[OutStateYes],[OutStateNo]))
The [InStateAndYes] is a field in the table which contains 7500, similarly the other fields contain:
Can this be done?
Thanks for your time.