iif

marks for the field name Eligible followed by a colon, IIf, the test [PitchScore]>=75, "Yes" for true and blank "" for false — each syntax element is independently checkable, the same way an Excel formula's pieces are marked individually. IIf is Access's IF with three parts (test, true result, false result): the exact query-grid equivalent of Excel's IF(test, value_if_true, value_if_false), just under a different name because Access reserves the bare word "If" as a programming keyword elsewhere in the application. Do not write "No" or "False" because the question asks for blank — an empty string "" and the word "No" are different values entirely; a check comparing the field's contents for genuinely blank would fail against either literal word.