In my query I need to format to If [fieldName] Is Not Null show "Yes", if the field is null show "No"
Try, iif(isnull([fieldName]), "No", "Yes")
Forum Rules