IIf expression with multiple criteria (1 Viewer)

I'm attempting to create a query field with an IIf expression to lookup three checkbox fields for their value and if the value is "No" in all three fields I want to return a question mark "?" but it's resulting in a syntax error.

It appears to be an issue with the whole expression because I've tried changing the "?" for a string but it still results in a syntax error.

The expression I'm trying is:

=IIf([FieldA]=”Yes”,”A”,IIf([FieldB]=”Yes”,”B”,IIf([FieldC]=”Yes”,”C”,”?”)))

Click to expand...

maybe got to do with your double quote mark on your expression, try:

if your fields are all string (text).

=IIf([FieldA]="Yes","A",IIf([FieldB]="Yes","B",IIf([FieldC]="Yes","C","?")))

if it is boolean.

=IIf([FieldA]=True,"A",IIf([FieldB]=True,"B",IIf([FieldC]=True,"C","?")))

Changing from "Yes" to True worked. Thank you, as ever.