I am trying to do the following update, with this result:
Participate in XXX
EOY Review
[SDE].[CodeXXX]
Participate in ZZZ
EOY Review
Yes
IIf([SDE].[InstructionalSetting]=7,Yes,No)
Data type mismatch in criteria expression
The first expression is working, [SDE].[CodeXXX] is a Boolean expression (0 or 1) and I get the desired result in the Participate in XXX check box.
Participate in ZZZ is a check box that I want to set to YES if InstructionalSetting is a 7 a text field.
Will I have to do a separate update?