Calc Field - IIF Statement

[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

[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