Page 1 of 1
Calc Field - IIF Statement
Posted: Fri Jun 22, 2007 9:45 am
by seg0906
I want to create a calculated field similar to:____If((field1=X AND field2=y),"Yes", "No") - however I get an error when doing this - seems like the If Statement will not allow and "AND" - is there any way to calculate a field like this?____Thanks,__Sarah
=> RE: Calc Field - IIF Statement
Posted: Mon Jun 25, 2007 9:32 am
by kfleming
You can use AND/OR operators in an IIF. You just need to make sure that the expression evaluates to either true or false and that you have correctly used any literal values. Strings need to be in quotes and dates need to be in square brackets.____And the two return values from the IIF need to be the same data type.____Kathleen__R&R Support