Sum with "Iif, and, or" criteria

[gmazza76]

Good morning

This I think is possibly a simple query, but I cant for the life of me think of a way to do the calculation in the query.

In essence I need an output of 1 to show if Q1 is <> "No" and Q2 = Yes

Output Outcome: Sum(IIf([Q1]="Yes" Or [Q1]="N/A" And [Q2]="Yes",1,0))

Apologies, but I am going round in a circle

thanks
Gavin

 

[welshgasman]

IIF(Q2="Yes" AND Q1<> "No",1,0)