If I use this calcuation in a field I have a problem when I select the calculated box, then select the field Office from the drop down list. The problem is that under the Summary box to the right the selection "count" is already selected and I can’t get rid of it. It should say None.
The error says, "Calculated field contains an invalid field references!" But this works all of the rest of the time.
IIF([TblName.FieldName]="STOCK RIDER SANTA FE","STOCK RIDER SANTA FE","")
Any ideas would be greatly appreciated. Thanks Rick