Simple Query Problem

[brendanolear]

New to Access and unable to reconcile this query.

My current query is as follows

Name:IIF([Master]![Name1]="Alpha" OR [Master]![Name1]="Beta","Yes","No"

which gives me results as expected

I wish to amend it to:

Name:IIF([Master]![Name1]="Alpha" OR [Master]![Name1]="Beta" AND [Master]![CCode]<>"BA06","Yes","No"

To exclude any "CCodes" of "BA06"

I'm clearly missing a parameter - grateful for advice.

 

[Joe4]

When you have ANDs and ORs in the same expression, you will need some more parentheses to indicate the hierarchy, or else it will make some assumptions that you may not be happy with. You are also missing a parenthesis at the end. I believe this is what you are looking for:

Name:IIF(([Master]![Name1]="Alpha" OR [Master]![Name1]="Beta") AND [Master]![CCode]<>"BA06","Yes","No")

 

[brendanolear]

Perfect Joe thanks